Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
aleira271
Contributor
Contributor

Problem sorting a dimension in pivot table

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

Captura de Pantalla 2020-02-21 a la(s) 10.14.05.png

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!

 

 

 

 
Labels (1)
0 Replies