Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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. 

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.