Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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

karthigayan
Creator II
Creator II

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