topic Re: Selection in Pivot Table in QlikView

Selection in Pivot Table

Fri, 28 Aug 2015 02:58:22 GMT

Hi,

I have a question about selection in pivot table,

I want to select data based on total value.

This one is the data shown when there's no input on percentage.

When i input the percentage, let's say range between 70 - 80 so, i want to check the total value, on above table is 73% for person A and 65 % for person B. So i want to show only data from person A. This is the data i expect

I also attach my sample file for additional information what i've done.

really appreciate your help, Thanks

Re: Selection in Pivot Table

lironbaram — Fri, 28 Aug 2015 05:25:30 GMT

have a look at the attach example

Re: Selection in Pivot Table

Fri, 28 Aug 2015 05:29:54 GMT

Hi Liron,

Wow yes that's right Liron. You are a great problem solver. Thanks for your idea.

But may I know how to make it ? what did you change ?

Re: Selection in Pivot Table

lironbaram — Fri, 28 Aug 2015 05:32:42 GMT

i added a total qualifier to the expression when checking if the result is in the range

so for all branches of a person the expression uses the total value of the person

Re: Selection in Pivot Table

Fri, 28 Aug 2015 10:07:07 GMT

Wow big thanks Liron.

You solved my problem perfectly.

Thanks