Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Selecting dates, while holding the primary criteria.

Good day,

I may be overthinking this, or not thinking clearly about the scenario. I have a selection requirement that must be able to select dates, while still holding the basic criteria constant:

Lets create a pie chart:

I have two "variables" that I need to see (C - 'CLASS', 'FP',  'GD',  'SMT', 'PET' and P - 'PC', 'PW',PREM').

These variables I have created on the variable t2: (there is also a selection button to selected between C and P)

     =if(match(t2, 'CLASS', 'FP',  'GD',  'SMT', 'PET',),'C', 'P')       

   

I have periods in my data:

201506, 201505, 201504

I can't seem to create the pie to show C and P overall, that when I select a period it shows C and P for the period selected, and when either C or P is selected individually, the overall view still shows. (C and P will be selected individually to view another graph on the sheet that will change when either is selected)

Any help will be much appreciated, hope I explained well enough

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this expression for the pie on the right: count({<t2=>}DISTINCT Acct_mk)


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I have trouble visualizing what you describe. Can you post a qlikview document that demonstrates the problem?


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Thank you for the reply.

I have attached a file.

I would like the pie on the left (an overall view)to show C and P for each period, once selected.

The pie on the right should change to the various subselection - should C or P be selected.

On Pie 1, should be {1} on the acct's but {$} on the period? How would we set this?

Pie 2 works as should.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try this expression for the pie on the right: count({<t2=>}DISTINCT Acct_mk)


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

It works perfectly, with the pie on the left once I used that formula.

Thank you very much - the light bulb came on!