Skip to main content
YOUR OPINION MATTERS! Please take the Qlik Experience survey you received via email. Survey ends June 14.
Showing results for 
Search instead for 
Did you mean: 

need help in pivot table

 Hi all, I need some urgent help

 I have pivot table

Dimension as person id  and the expression has how many Applications he has verified

 I have taken 5% of  the applications for each person id   for every month

 for the month  of the September I have taken the expression as

=if(Count({<MonthYear = {"Sep20"}>}DISTINCT[Review ID])*0.05<=77,
Count({<MonthYear = {"Sep20"}>}DISTINCT[Review ID]

Now I want to show the personids in the pivot table itself as rows in QlikView.

Please find the attached qvw, I need very urgent , can you please help me.



Labels (1)
1 Reply
Partner - Contributor III
Partner - Contributor III

Can you please provide some more details?  Maybe create a mock up in Excel of what you want the pivot table to look like with a few rows?