Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!