topic Re: Date ranges in chart in QlikView

Date ranges in chart

shree909 — Tue, 23 Apr 2013 22:26:25 GMT

Hi,

i have a bar chart with date and Dimension 1 as Dimenions and one expression.

i have list boxes for Month, Year ,,

The issue i have is by default i have to select 30 days range in the chart with the Date..

i used dimension limits to filter but its showing either first,largest 30 values..

i want to show it as a last 30 days whaterver the expression values as ..

so when i filter on month its shows that month dates and values but for default the chart is messed up with all the dates till today..

So how can i filter and show as last 30days in the chart by default.

My expression is = sum({<system_name ={'ABC'}> }factvalue)

Help would be really Appreciated..

MayilVahanan — Tue, 23 Apr 2013 22:35:56 GMT

Try with set analysis

= Sum({<Date = {">=$(=Max(Date)-30)<=$(=Max(Date)-1)"}>}Sales)

=Max(Date)-1 , if maximum date is today(), then its not considered today.

>= today() - 30

<= today()-1

Edit:

= sum({<system_name ={'ABC'}, Date = {">=$(=Max(Date)-30)<=$(=Max(Date)-1)"}> }factvalue)

hope it helps

shree909 — Tue, 23 Apr 2013 23:03:47 GMT

That works perfect..

Thanks