Difference/Trend based on Month(s) field - Retention

[qlikwiz123]

I have the following Data model with the fields:

Month

Customers

Month          Customers

Jan                200

Feb                150

Mar                170

Apr                 220

.                        .

.                       .    

Dec                  80

I need to provide users option where the users can select any month or months and the difference between the selected month(s) and the remaining months should be populated.

For example, if the user selects Jan, the following output should be seen

Month          Customers           Difference

Jan                200                    0

Feb                150                   50

Mar                170                   30

Apr                 220                  -20

.                        .                     .    

.                       .                      .

Dec                  80                  120

The user should be able to pick any month or months instead of Jan, dynamically and based on the selected month, the Difference column should be calculated.

[devarasu07]

Hi,

Try to use above function,

create measure like below

alt(sum(Customers)-Above(Customers),0)

[pradosh_thakur · Accepted solution]

may be this

[qlikwiz123]

My requirement is a bit different.

The User should be able to pick a month and the difference should be based on the selected month.

For example, if the user selects March, the difference for all the months should be (March ~ Individual Months)

[qlikwiz123]

Hi,

Thank you so much. Can we do the same thing for multiple months? In case, if the user selects two or months, for example, Jan and Feb, the result should be (Jan + Feb) ~ each individual remaining months.

[pradosh_thakur]

yes.

month filter has always one selected value . uncheck that and select multiple months , it shall work.

but let me warn you i have used alternate states here. you can do the other way around and use table in alternate state and filter in inherited state.

[qlikwiz123]

Selecting multiple months is not giving the right numbers in the result column. Any changes needed for the expression?

[pradosh_thakur]

this is what i am getting . feb+jan - months . is the requiremnt diffrent. if so please post the expected output

[qlikwiz123]

The state works for once and gives correct values soon after. But when I change the sheet, reload data or close and open the file, the state isn't working.

[qlikwiz123]

The Alternate state gives out the result column when created. But later doesn't give the values which are correct. Strange. Any reason why it is behaving this way