What if by calculation (not by variable) challenge

marcel_olmo — Mon, 03 Nov 2014 18:09:48 GMT

Hi guys,

I've been developed many what if comparisons where the "what if" number of the slider is a variable which is usually multiplied with the calculations of your own metrics.

But what about if I want to see it in an opposite way? Here's an example :

I want to know all the customer how many customers have bought a 10% less this year than the current year.

I'm wondering if I can do it with the "slider what if way".

If I have a chart table like this :

Customer	Year 2014	Year 2013	Diff %
cust1	190 €	200 €	-10%
cust2	180 €	200 €	-20%
cust3	170 €	200 €	-30%
cust3	160 €	200 €	-40%

And a slider like this :

If I select the 0-10% option, it will show only the first customer :

Customer	Year 2014	Year 2013	Diff %
cust1	190 €	200 €	-10%

Is there any dummy example which shows how to do it this way?

Regards, Marcel.

Re: What if by calculation (not by variable) challenge

JonnyPoole — Mon, 03 Nov 2014 18:31:59 GMT

Here is an example with a data island, class() function, and IF() in the chart expression:

Re: Re: What if by calculation (not by variable) challenge

JonnyPoole — Mon, 03 Nov 2014 18:59:30 GMT

Here is an example with a data island, class() function, and IF() in the chart expression:

topic What if by calculation (not by variable) challenge in QlikView

What if by calculation (not by variable) challenge

Re: What if by calculation (not by variable) challenge

Re: Re: What if by calculation (not by variable) challenge