Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
boonhaw_tan
Contributor III
Contributor III

Bar chart show latest 3 months sales if no selection

Hi All,

I need to build to bar chart show sales by month.

There is a requirement to show latest 3 months of sales if no selection.

Also it need to display sales based on user selection.

Really appreciate for any advice.

e.g:

- If no selection, display sales for 201707, 201708 & 201709

- Display sales for 201701 & 201708, if user select 201701 & 201708  

YYYYMMSales
201701100
201702200
201703300
201704100
201705200
201706300
201707400
201708500
201709600

Thanks,

Boon Haw

1 Solution

Accepted Solutions
antoniotiman
Master III
Master III

Hi,

Dimension : YYYYMM

Expression :

If(GetSelectedCount(YYYYMM)=0,Sum({<YYYYMM={">=$(=Max(YYYYMM,3))"}>} Sales),Sum(Sales))

Regards,

Antonio

View solution in original post

2 Replies
antoniotiman
Master III
Master III

Hi,

Dimension : YYYYMM

Expression :

If(GetSelectedCount(YYYYMM)=0,Sum({<YYYYMM={">=$(=Max(YYYYMM,3))"}>} Sales),Sum(Sales))

Regards,

Antonio

boonhaw_tan
Contributor III
Contributor III
Author

Thank you so much for response and it work well