Display Output from different queries in one table in VC

[Former Member]

Hi all,

I have a requirement to show following things in one table in VC in following format.

ActualMonth BudgetMonth LVMonth ActualYTD BudgetYTD LVYTD

Sales Volume 10,000 11,000 10,500 110,000 120,000 119000

Marketing FC 40 50 56

Gross Margin 1000 1500 1250 6000 7000 6500

Trading Profit 80 100 85 300 350 325

Debtors 123 119 130 123 119 130

Now the problem is that behind every cell , there is a separate quey. for example for Actual Month Sales Volume, I have a query that just gives a number in output and for Actual YTD Sales Volume, I have a separate query that again gives a number in output.

How can i show data from all queries in one table in VC? Is that possible?

Please respond.

Regards,

Aisha Ishrat

ICI Pakistan Ltd.

[Former Member]

Resolved myself.

[Former Member]

Please ,

can you share how did you solve the issue

i am using combine operator but i am not getting any output in output table after combine

[Former Member]

Hi Aisha,

Try to use 'Union'. Create one table for of your query and use 'Union' to put values in only one table. The queries, as pointed Ari Kumar, should have at least one common field.

Regards,

Gilson

[Former Member]

Hi Gilson,

No field is common in all queries as some queries get data from excel and some queries get data from standard cubes. The output of all queries is just a number.

Any way to put all values in one table?

Regards,

Aisha Ishrat

ICI Pakistan Ltd.

[Former Member]

Hi,

are the queries all SAP BI queries? If yes then you can bring them together in one query.

Best Regards,

Marcel

[Former Member]

Hi Marcel,

Yes all are SAP BI queries but all queries have different input variables and the output of every query is just a single number.Any way to display all values in one table in VC?

Regards,

Aisha Ishrat

ICI Pakistan Ltd.

[Former Member]

Hi Al,

the different input parameter doesn't matter. If you use two structures in your query you can define cells, so that every value of your queries can displayed in one cell and then you can display it in a table in Visual Composer.

Best Regards,

Marcel

[Former Member]

Thanks Marcel.

I have got my required output while using "Combine" operator.

Regards,

Aisha Ishrat

ICI Pakistan ltd.