Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this expression for the pie on the right: count({<t2=>}DISTINCT Acct_mk)
I have trouble visualizing what you describe. Can you post a qlikview document that demonstrates the problem?
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.
Try this expression for the pie on the right: count({<t2=>}DISTINCT Acct_mk)
It works perfectly, with the pie on the left once I used that formula.
Thank you very much - the light bulb came on!