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

[jblomqvist]

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.

[#2]

Hi John,

try the below

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

hope that helps

Joe

[jblomqvist]

Hi Joe,

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

[sunny_talwar]

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.

[jblomqvist]

Hi Sunny,

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

[sunny_talwar]

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.

[jblomqvist]

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%.

[#8]

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

[kaushiknsolanki · Accepted solution]

Hi,

Have a look at the attached application.

Hope this is what you want.

Regards,

Kaushik Solanki