topic Re: To sort the measures in pivot table by descending order in App Development

To sort the measures in pivot table by descending order

drey90 — Mon, 20 Dec 2021 21:38:40 GMT

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.

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

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.

Re: To sort the measures in pivot table by descending order

anushree1 — Thu, 20 Feb 2020 09:22:52 GMT

Please check this

https://www.youtube.com/watch?v=iiMlRVJWmsk

Re: To sort the measures in pivot table by descending order

drey90 — Thu, 20 Feb 2020 09:31:13 GMT

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.