Pivot table in Qlik Sense

[achakilam1022]

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.

[kaushiknsolanki · Accepted solution]

Hi,

Try this expression for %.

Count(SchoolProgram)/Count(Total<Month> SchoolProgram)

Regards,

Kaushik Solanki

[achakilam1022]

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.

[kaushiknsolanki]

Sure,

Can you create a new discussion and explain with example what you want.

Regards,

Kaushik Solanki

[achakilam1022]

Surely.

Thanks