Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

achakilam1022
Contributor

Pivot table in Qlik Sense

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.

1 Solution

Accepted Solutions

Re: Pivot table in Qlik Sense

Hi,

Try this expression for %.

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


Regards,

Kaushik Solanki

4 Replies

Re: Pivot table in Qlik Sense

Hi,

Try this expression for %.

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


Regards,

Kaushik Solanki

achakilam1022
Contributor

Re: Pivot table in Qlik Sense

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.

Re: Pivot table in Qlik Sense

Sure,

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

Regards,

Kaushik Solanki

achakilam1022
Contributor

Re: Pivot table in Qlik Sense

Surely.

Thanks