Selecting dates, while holding the primary criteria.

[Anonymous]

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

[Gysbert_Wassenaar]

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

[Anonymous]

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 · Accepted solution]

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

[Anonymous]

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

Thank you very much - the light bulb came on!