topic Re: Bar Chart limit condition in QlikView

Bar Chart limit condition

danialier — Wed, 19 Feb 2014 17:59:00 GMT

Hello,

I have a bar chart with two expression showing the sales of the products A and B in columns. Moreover I have a list box with these two products.

I want the bar chart to display the products I select in the list box, so:

> If I select product A I just want product A to be displayed in the bar chart.

> If I select product B I just want product B to be displayed in the bar chart.

> If I select product A and B I want product A and B to be displayed in the bar chart.

Which is the conditional I should use in the conditional expression ?

thanks,

dani

Gysbert_Wassenaar — Wed, 19 Feb 2014 18:03:24 GMT

Why can't you add the Products dimension to your bar chart? That way you won't need to mess around with conditional expressions.

You could use this if you do need/want to use conditional expressions and your products dimension is named Product:

For product A: if(substringcount(concat(distinct Product & '~', ','), 'A~')),1,0)

For product B: if(substringcount(concat(distinct Product & '~', ','), 'B~')),1,0)

santharubban — Wed, 19 Feb 2014 18:25:27 GMT

try this,

if(product A,1,if((product A and product B),1,0)) and similar for product B