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