Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?