Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Range Selection

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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Date Range Selection

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.

3 Replies
israrkhan
Valued Contributor II

Re: Date Range Selection

hi,

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

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

Khan

MVP
MVP

Re: Date Range Selection

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.

Not applicable

Re: Date Range Selection

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

Community Browser