Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

How to Sort Pivot Table based on Field that is not present as Dimension nor Measures in pivot Table

Hi All,

I am creating pivot Table in Qlik Sense.

Below is the detail about Table.

Dimension :

1.Bundle

2.Initiative.

3.Project

4.Parent Task

5.Task

 

Measures:

Min({<TaskIsMilestone={1},ProgramRollup={1}>}Start Date)

Max({<TaskIsMilestone={1},ProgramRollup={1}>} Finish Date)

Sum({<TaskIsMilestone={1},ProgramRollup={1}>}TaskPercent)

 

I want to sort this pivot table based on Field "TaskClientID"

1 Reply
trdandamudi
Honored Contributor II

Re: How to Sort Pivot Table based on Field that is not present as Dimension nor Measures in pivot Ta

In the pivot chart go to "Sorting" and for the first field select "Custom" under Sorting. Then  put a check mark against "Sort by Expression" and enter your field "TaskClientID". Also make sure you un check both "Sort numerically" and "Sort alphabetically".

Hope this helps..

 

PivotTableScreenShot.PNG