Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
MarioCenteno
Creator III
Creator III

Current Month Dimension QS

I am trying to show in a graph the sales of the current month by day, my expression is correct but the dimension does not adjust to the days of the current month. Could you help me?

For September the graph should arrive at 24 and show me the full month from 1 to 30.

Dimension:

Day(DATE)

Expression:

SUM({<[Date.autoCalendar.Year]={'$(vMaxYear)'},

[Date.autoCalendar.Month]={'$(vMaxMonth)'},[Date.autoCalendar.Day]={'<=$(vMaxDay)'},

Date=,[Date.autoCalendar.YearMonth]=>}SALES)


qlk.png

4 Replies
OmarBenSalem
Partner
Partner

How is the vMaxDay defined?

If u put it in a KPI object, what does it return?

Try sthing like :

SUM({<[Date.autoCalendar.Year]={'$(vMaxYear)'},

[Date.autoCalendar.Month]={'$(vMaxMonth)'},

Date={"$<=(=Date(today(1)))"},[Date.autoCalendar.YearMonth]=>}SALES)

MarioCenteno
Creator III
Creator III
Author

It returns data from 1 to 24 September, so it should be shown in the graph, I have to do a calculated dimension I guess.

OmarBenSalem
Partner
Partner

What returns data from 1 to 24?

MarioCenteno
Creator III
Creator III
Author

Right