Problem sorting a dimension in pivot table

aleira271 — Sat, 16 Nov 2024 01:13:17 GMT

Hi everybody, I want to order the dimension called sub reason by %/total expression in descending way by subreason but I can't.

This is the calculation for the expression:

=if(Dimensionality()=1,
count({<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)
/count(total {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid),
if(Dimensionality()=2,count( total <sub_reason_c> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)
/count(total <main_reason> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)))

And I am trying to sort by this expression:

count( total <sub_reason_c> {<action={'contact'},AñoMes_Nro = {$(vAnoMesAnt)}>} self_support_logid)

I attach the .qvw file. The problem is in CX tab.

Thanks!

topic Problem sorting a dimension in pivot table in QlikView

Problem sorting a dimension in pivot table