Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Grouping Dimension line chart

 
 
Hello, I would like to group in my line chart, for example: Qtr0 = M24 + M23 + M22 ans show %; in the original line chart it shows everything perfectly 
But when I group in the dimension it shows nothing.

tendencia qtr.PNG

Dimensions:

/*

=if(Mes='M24'or Mes='M23'or Mes='M22' or Mes='M21' or Mes='M20' or Mes='M19' or Mes ='M18'or Mes ='M17'or //Mes='M16'or Mes='M15'or Mes='M14' or Mes='M13',Mes)

M24='202003'Qtr0
M23='202002'Qtr0
M22='202001'Qtr0

 

Result when grouping Dimension:

=if(Mes='M24'or Mes='M23'or Mes='M22','Qtr0',
if(Mes='M21' or Mes='M20' or Mes='M19','Qtr-1',
if(Mes='M18' or Mes='M17' or Mes='M16','Qtr-2'
)))

 
 

*/

error group.PNG

 

Labels (1)
0 Replies