Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I'm new to qlik and I'm having a little trouble with pivot tables.
I have a pivot table with Rows as School Program; dimension in columns is Month and the measure is Count(SchoolProgram)
May I know how to get these measures as percentage of month total.
Thank you.
Hi,
Try this expression for %.
Count(SchoolProgram)/Count(Total<Month> SchoolProgram)
Regards,
Kaushik Solanki
Hi,
Try this expression for %.
Count(SchoolProgram)/Count(Total<Month> SchoolProgram)
Regards,
Kaushik Solanki
Thank you Kaushik.
Can you help me in generating a final column in pivot table which consists of sum of the row values and then show them as percentage of that column.
Thanks again for your help.
Sure,
Can you create a new discussion and explain with example what you want.
Regards,
Kaushik Solanki
Surely.
Thanks