Displaying the result of 2 filters in a single table

[Former Member]

Hi experts,

I have 2 filters which returns me 2 different set of values.

How can i display these different set of values in a single table ???

Its urgent ..could anyone help me out ???

Ur suggestions will be rewarded.

Thanks.

Pratima.

[Former Member · Accepted solution]

Hi,

maybe you mean the union or the combine operator?

Select "compose" tab, an then click "Additional Operators".

Place the operator between your filters and your table.

Combine can combine different fields on a certain key field, while union will only work if the two filters deliver the same fields.

Best Regards, Benni

[Former Member]

Hi Mario,

ur suggestion was helpful ...but the thing is that when i implement ur suggestion i get the output table as

Profit/Loss Profit KF Loss KF

Prf1 100

Lss1 200

But this is not what i want ...

i dont want 2 columns with diff profit loss values..

the ouptut which i want is only 2 columns ... but 2 row headers...

one row header will be named as profit and below that all the profit values will be displayed ... and another row header below that for Loss which will have all the loss values just below the header ..

u can see the example below ...

here Profit and Loss are my row headers ... and Prf1 and Lss1 are the values...

Profit Amount KF

Prf1 100

Loss Amont KF

Lss1 200

Could u plz suggest me how to implement this table...

Thanks,

Pratima.

[Former Member]

Then put your 2 key-figures in the rows and the characteristic in the columns

[Former Member]

Hi Mario,

i dont have 2 key figures... only one which will have the profit loss values . i have one characteristic field which has profit loss ie. "D" for profit and "C" for credit ...

which distinguishes the key figues..

i need to display theses values seperately in a table..

Thanks.

Pratima.

[Former Member]

hi

I dont know how you can display them in a table but can tell you a workaround by using listboxes instead of table and conbine list boxes such that in appearance it gives look of a table.

Thanks & Regards

Harsimran

[Former Member]

That's why I tell you to build 2 restricted key-figures. Go into BEx Query Designer, and create based on your one key-figure two restricted key-figures. One key-figure filtered=restricted on D, the other one on C. Look up BW-modeling

Than you have 3 key-figures available: the original one, and the two restricted. Drag&Drop the restricted ones in your query.

If you don't know how to do that, get a BW-guy and ask him/her to help you.

[Former Member]

Hi experts,

I am using BI query .... then in the output of the query in m using 2 filters which will be give me 2 diff values ... lets say ...one query gives me values related to profit and the other filters returns me the loss values ...

Now i want to dislay the profit loss values in a single table ....

i tried with union operation ..but it was not working ....

Please help me out ...

Ur suggestions wil be rewarded.

Thanks,

Pratima.

[Former Member]

You need to design the query properly on the BI. I assume that you use 1 BI query with 2 different sets of filter (and not 2 BI queries).

Create 2 restricted key-figures, one restricted on the characteristic value that returns you the profit, the other key-figure on the losses. Then put those 2 key-figures in the e.g. columns section of your query and use this query.

[Former Member]

As Mario mentioned, please give us more information about your scenario.

Best Regards,

Marcel

[Former Member]

What does it mean "2 filters"? Are you using 2 queries? What type of queries? If they are BI queries, are those variables and/or filters?

What exactly do you want to see? Something like a join? A Union?