topic Re: How can I stop my output from expression updating when users make selections? in QlikView

How can I stop my output from expression updating when users make selections?

jblomqvist — Mon, 24 Aug 2015 15:22:36 GMT

Hi all,

I have the following table

The Percentage should stay the same if someone selects a ClaimType.

At the moment if I make a selection it recalculates to 100% like below:

I don't want this to happen and would like it to remain 6.67% for example.

How can I get it to ignore selections and show my the actual result?

My Percentage expression is: sum(Value)/sum(TOTAL Value)

Anyone know what I need to do to my expression?

I attach the app for you.

Re: How can I stop my output from expression updating when users make selections?

Mon, 24 Aug 2015 15:25:10 GMT

Hi John,

try the below

sum(Value)/sum(TOTAL<ClaimType> Value)

hope that helps

Joe

Re: How can I stop my output from expression updating when users make selections?

jblomqvist — Mon, 24 Aug 2015 15:27:09 GMT

Hi Joe,

Thanks for your reply. I tried this but then I get the same value across all the dimensions:

Re: How can I stop my output from expression updating when users make selections?

sunny_talwar — Mon, 24 Aug 2015 15:36:58 GMT

Try this may be:

If(Sum(Value) > 0, Sum(Value)/Sum(TOTAL {1} Value))

Update: Unable to test if the expression works or not because I am working with personal edition of QlikView.

Re: How can I stop my output from expression updating when users make selections?

jblomqvist — Mon, 24 Aug 2015 15:39:07 GMT

Hi Sunny,

This still does the same as Joe's result and recalculates so it does not work unfortunately.

Re: How can I stop my output from expression updating when users make selections?

sunny_talwar — Mon, 24 Aug 2015 15:42:14 GMT

Are you sure you have used this expression:

If(Sum(Value) > 0, Sum(Value)/Sum(TOTAL {1} Value))

Because the result should be Different from Joe's result as I don't have <ClaimType> in the denominator.

Re: How can I stop my output from expression updating when users make selections?

jblomqvist — Mon, 24 Aug 2015 15:45:39 GMT

Hi Sunny,

Thanks for your reply. It recalculates it to 100% for any selection. So for example for Internal it goes from 6.67% to 100%.

Re: How can I stop my output from expression updating when users make selections?

Mon, 24 Aug 2015 15:46:01 GMT

maybe go with

sum(Value)/sum(TOTAL {1} Value)

then, you will need to remove the deselect 'relative' on the expression which you have set

Joe

Re: How can I stop my output from expression updating when users make selections?

kaushiknsolanki — Mon, 24 Aug 2015 15:46:02 GMT

Hi,

Have a look at the attached application.

Hope this is what you want.

Regards,

Kaushik Solanki