topic Where in an expression in QlikView

Where in an expression

Thu, 05 Mar 2015 10:40:30 GMT

Qlikview is new to me and am struggling with this:

I have 3 charts running from the same bit of script, each chart shows a sum of a count by a different category.

For example I want the first chart to show Where product='CARS'

The second to show Where product='PLANES' etc.

I don't want to change my script by putting in a Where statement.

I have tried conditional and Calculation condition and neither has worked. Although this might be how I have written the condition.

Can anyone help?

It seems like it should be straight forward but I am struggling to find the answer.

Thu, 05 Mar 2015 11:15:05 GMT

That is Set Analysis.

Change your expression on the chart something like

SUM({$<product={"CARS"}>} Sales)

Here is a video from @Michael Tarallo

Anonymous — Thu, 05 Mar 2015 11:21:00 GMT

where condition can be written in expression with the help of set analysis.

Like:

In ur expression : sum({<Product={'CARS'}>}Sales)

and in the other chart

sum({<Product={'PLANES'}>}Sales)

Thu, 05 Mar 2015 12:05:35 GMT

Thank you that is great and much appreciated