topic Multiple Calculation Condition in QlikView

Multiple Calculation Condition

Wed, 08 Feb 2012 15:53:03 GMT

Hi,

I would like to display charts or tables only if 2 values from the same filters selected.

I Tried several syntaxes without success such as :

=FILTER = 1011 and FILTER= 1002 or =FILTER = '1011' and '1002'

Is someone could advise?

Thanks a lot

Jason_Michaelides — Wed, 08 Feb 2012 16:36:44 GMT

Try this in the show condition:

Concat(DISTINCT FILTER,',') = '1002,1011'

This will mean the chart will only show if both 1002 and 1011 are selected, and no other values.

Hope this helps,

Jason

Message was edited by: Jason Michaelides - Changed calculation condition to show condition

Wed, 08 Feb 2012 17:35:35 GMT

Hi Jason and thanks for your quick answer.

I applied your formula and the result is that the table is displayed when i select the two values or any so i'm not yet at the result expected.

In fact the display is hidden only if i select one value or the another.

Jason_Michaelides — Wed, 08 Feb 2012 17:52:48 GMT

Hi,

Please post your app and I'll have a look tonight when I get home.

Jason

Wed, 08 Feb 2012 19:03:23 GMT

Jason,

I rewied my orignal request to check my data and reapply your formula.

It works now

Thanks again

Jason_Michaelides — Wed, 08 Feb 2012 19:39:45 GMT

Jolly good.

Thu, 21 Feb 2013 12:32:44 GMT

how would you then filter on 2 selected fields but from 2 different listboxes??