topic Re: Date Range Selection in QlikView

Date Range Selection

Sat, 12 Oct 2013 09:09:09 GMT

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?

Re: Date Range Selection

israrkhan — Sat, 12 Oct 2013 10:02:29 GMT

hi,

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

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

Khan

Re: Date Range Selection

jagan — Sat, 12 Oct 2013 10:07:39 GMT

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.

Re: Date Range Selection

Sat, 12 Oct 2013 11:52:56 GMT

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