topic Re: Selecting dates, while holding the primary criteria. in QlikView

Selecting dates, while holding the primary criteria.

Anonymous — Wed, 05 Aug 2015 09:08:48 GMT

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

Re: Selecting dates, while holding the primary criteria.

Gysbert_Wassenaar — Wed, 05 Aug 2015 10:45:28 GMT

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

Re: Selecting dates, while holding the primary criteria.

Anonymous — Wed, 05 Aug 2015 11:13:05 GMT

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.

Re: Selecting dates, while holding the primary criteria.

Gysbert_Wassenaar — Wed, 05 Aug 2015 11:56:49 GMT

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

Re: Selecting dates, while holding the primary criteria.

Anonymous — Wed, 05 Aug 2015 12:34:46 GMT

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

Thank you very much - the light bulb came on!