Qlik Community

App Development

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

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
drey90
Contributor II
Contributor II

To sort the measures in pivot table by descending order

Hi, 

I need help from Qliksense application development. 

I would like to sort the measures by descending order in pivot table. I am using button extension to click descending order.

For example, the snapshot below show the table without sorting. 

IM_Exposure_Sort.jpg

Once "Daily Change Desc" button is clicked, i should see the sorting but it is not working. 

IM_Exposure_Sort2.jpg

Formula used:

rank(fabs(SUM({<EXP_VALUATION_DATE={"$(vMaxValDate)"}, EXP_IM_ROLE={"$(vIMRole)"},EXP_MATCH_IND={"$(vMatchInd)"}>}EXP_IM_EXPOSURE) - SUM({<EXP_VALUATION_DATE={"$(vPrevValDate)"},EXP_IM_ROLE={"$(vIMRole)"},EXP_MATCH_IND={"$(vMatchInd)"}>}EXP_IM_EXPOSURE)),4,1)

I should see the sorting like

8979704

341686

111193

Appreciate if someone can help me with this. Thanks. 

Labels (1)
2 Replies
anushree1
Specialist II
Specialist II

drey90
Contributor II
Contributor II
Author

This video is not useful as the developer ignore the null values to sort it. 

I did not ignore the null values. All values must be shown in the pivot table, including nulls.