Discussion Board for collaboration on QlikView Scripting.
I am looking to get a unique row count per calculated dimension in a Pivot Table
This is how I want the data to be represented
I have attached the raw data
Period, Row Number
Innings. 2 1
Innings. 3 1
Go to Solution.
Please find attached qvw file.
What issue you are facing while doing same??
Thank you for your response
I want to know the number of rows per innings and not the total row count
I get the data as follows in the Pivot Table
Innings. 2 4
Innings. 3 10
Have you tried RowNo()?
Thank you Nilesh
Please mark the post as answered.