Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot Table Calculation

Hi Friends,

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

pivot.png

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)

input.png

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)

rank.png

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.

new column.png

Thanks in Advance,

Pooja

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

And maybe an option to answer question 3

View solution in original post

4 Replies
Highlighted
MVP
MVP

Attached suggested solutions for the first two questions.

Highlighted
MVP
MVP

And maybe an option to answer question 3

View solution in original post

Highlighted
Not applicable

Your Answer is as expected Thank you so much.

Highlighted
Not applicable

Hi,

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

Q1

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.

Pivot New.png

Regards,

Pooja