Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sachinmanan
New Contributor III

how to sort count in decending order in pivot table

I have industry names in dimension & i am totaling no. of email ids that i have against each industry. Now i want to arrange count of email ids in descending order so that industry with maximum email ids should come on the top

Tags (1)
1 Solution

Accepted Solutions

Re: how to sort count in decending order in pivot table

Go to Sort tab and write below in Expression .....

COUNT(Distinct EmailID)

Select Descending Order....

Also, change appropriate FieldName

7 Replies

Re: how to sort count in decending order in pivot table

Go to Sort tab and write below in Expression .....

COUNT(Distinct EmailID)

Select Descending Order....

Also, change appropriate FieldName

sachinmanan
New Contributor III

Re: how to sort count in decending order in pivot table

thank you very much ... this helped.

Now i am adding dates also as a dimension. what i now want is industry wise, date wise, count of email ids in descending order. what should i do?

Re: how to sort count in decending order in pivot table

Provide Sample Data...

Please note that Interactive Sorting is not possible in Pivot Table... You need to sort by First Dimension then Next ....

sachinmanan
New Contributor III

Re: how to sort count in decending order in pivot table

IndustryDateopen18-08-1420-08-1421-08-1425-08-1401-09-14
Total 3434667279581
BPO /KPO 915358775
RETAIL 902027076
Services ----94
Information Technology ----71
MANUFACTURING 34953121
OEM 39182221
sachinmanan
New Contributor III

Re: how to sort count in decending order in pivot table

Many thanks Manish... its resolved

Re: how to sort count in decending order in pivot table

Kindly close the thread by selecting correct/helpful answer

sachinmanan
New Contributor III

Re: how to sort count in decending order in pivot table

i dont know how to close a thread... i am new to this forum.. please guide