Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

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]
)*0.05,77)

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
gp_oconnor
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?