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

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

madhavi_rajawat — Tue, 13 Aug 2019 09:14:49 GMT

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"

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

trdandamudi — Tue, 13 Aug 2019 11:56:53 GMT

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..