Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
abhaytrip
Contributor

Show last 3 months label as selected

Hi all,

So the issue where im facing is displaying the label for eg in this case 'Jan-18' , 'Dec-17' ... etc

the info in the bar chart is previous 3 months including the current selected month , so in this case i have Jan-18 selected , so i need to view DEC-17 and Nov-17 info in the bar chart .

Can you help me out how to display the particular Month-Year when they are selected.

Snap12.PNG

2 Replies
Partner
Partner

Re: Show last 3 months label as selected

Sure you could use set analysis.
something like below. I used Max(OrderDate) so that when nothing is selected it still shows max date and 2 prior months
Sum( {<OrderDate={"<=$(=Max(OrderDate)) >=$(=MonthStart(Addmonths(Max(OrderDate),-2)))"}>} LineSalesAmount)
abhaytrip
Contributor

Re: Show last 3 months label as selected

Hi Dilipranjit ,

 I sure did use it , but there's one issue , if suppose I select June (Month) , 2018(Year) . I get desired results only for Jun-18 .

but instead the user might want to see the selected month and Previous 2 months of it as well.

is that possible ?