Date Range Selection

[#1]

I want to assign a particular date range in a chart. e.g From Previous Month till Date (Today), So that data displayed in the chart only shows the the data belonging to the previous month till the current day. how can I achieve this? Can anyone give me example of the expression I should use?

[israrkhan]

hi,

i think this will help you, if not let us know..

http://community.qlik.com/message/288110#288110

Khan

[jagan · Accepted solution]

Hi,

If you have a date field for example DateDimension in your data then use this

=Sum({<MonthDimension=, YearDimension=, QuarterDimension=, DateDimension={'>=$(=MonthStart(Today(), -1))<=$(=Today())'}>} Sales)

MonthDimension=, YearDimension=, QuarterDimension=,  Excludes the selection in Month/Year/QuarterDimensions

If you have Week or Day dimensions exclude like this

If this expression not works then check whether the date formats of the DateDimension and Today() are same.

Hope this helps you.

Regards,

Jagan.

[#4]

Thankyou for helping.. I have achieved the goal using Set Analysis