Qlik Community

Qlik Sense App Development

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

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master II
Master II

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