Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
ramrongala
Contributor II
Contributor II

Always show current month +Previous 5 months Data in Bar chart

Hello all,

i am working on qliksense applictaion .in front end i need to show for all the charts data should display only for current month and last five months it should display 

.also when i select filter month year based on selection it should display.

 

can you please help me it is very urgent

 

am using this condition but it is taking max month but i want to take current month and last five months

count(distinct {<[Created Month-Year]={">=$(=Date(AddMonths(Max(monthend([Created Month-Year])),-5),'MMM-YY'))<=$(=Max(monthend([Created Month-Year])))"} >}[Transaction ID])

Dimension:  [Created Month-Year]

 

 

 

 

 

 

Thanks in advance!

 

 

 

1 Reply
Claudiu_Anghelescu
Specialist
Specialist

Expr: count({<Date={'>$(=AddMonths(Max(Date),-6))'}>} sales)
Dimension: yourMonth
To help community find solutions, please don't forget to mark as correct.