Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Lala
Contributor
Contributor

When filter, the order of months does not work well

I have a bar chart that should show the current month and the previous 13 months.

On the x-axis I make a concatenation of year and month (the written month, not in number). This is my fx:

=if (GetSelectedCount(AÑO)=0 AND FECHA>=(Monthstart(Addmonths(TODAY(),-12))) AND FECHA<=TODAY(),
AÑO& ' ' &(MONTH(MakeDate([AÑO],MES))),
if(GetSelectedCount(DMES)<>0 AND FECHA>=vLimiteMenor AND FECHA<=vLimiteSuperior,
AÑO&' '&IF(LEN(MES)=1,'0'&MES,MES)
))

  • *DMES means written month
  • *MES means numer of month
  • *vLimiteMenor means =(Monthstart(Addmonths(DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY'),-12))) 
  • *vLimiteSuperior means  =DATE(FLOOR(Timestamp#(MAX(FECHA))),'DD/MM/YYYY')

When I filter, I also need to view the filtered month and the previous 13 months, so I used different methods: alternate states, method {1}... BUT WHEN FILTER, the order of concatenation does not work well.

 

Can someone help me? I do not know what I'm doing wrong

0 Replies