Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where in an expression

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.

3 Replies
Not applicable
Author

That is Set Analysis.

Change your expression on the chart something like

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

Here is a video from @Michael Tarallo

A Beginners' Introduction to Set Analysis

Anonymous
Not applicable
Author

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)

Not applicable
Author

Thank you that is great and much appreciated