topic Pivot Table Calculation in QlikView

Pivot Table Calculation

Wed, 25 Nov 2020 16:16:04 GMT

Hi Friends,

Need advice on the below requirement (pivot table) for the attached QVW file.

Q 1. Sum of "Based on Input Values" Column: (I need it in a variable):

Answer (For this given example): 90

Variable = 3 (This will change dynamically)

Q 2. Rank Column, we need the rank of 'Based on Input Values 'column.If the values are repeating need to give the same rank.

Variable = 3 (This will change dynamically)

Q 3. Need to find the top value from the column 'based on input values'. if the top value has the duplicates then v need to avoid that and have to find the next top value. Then v need to multiply the variable value with that value.

Thanks in Advance,

Pooja

Re: Pivot Table Calculation

swuehl — Sun, 19 Jun 2016 10:50:14 GMT

Attached suggested solutions for the first two questions.

Re: Pivot Table Calculation

swuehl — Sun, 19 Jun 2016 11:12:39 GMT

And maybe an option to answer question 3

Re: Pivot Table Calculation

Sun, 19 Jun 2016 14:59:48 GMT

Your Answer is as expected Thank you so much.

Re: Pivot Table Calculation

Sun, 19 Jun 2016 15:08:37 GMT

Hi,

Thanks for your Valuable solution but still i need the below changes. and I have attached the updated QVW file

When i am rounding the total values in the text object i am losing 0.01 from the 'Based on Input Values' column. So here i need to find out the difference in new variable. For this ex: it is 0.01 (It may vary when i am adding data in future).

for Q2

Here the 2nd rank is missing. Though the 1st rank is duplicate i still need to give 2nd rank to the next person.

Regards,

Pooja