Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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"
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..