topic Re: Limiting a dimension range (set analysis ?) in QlikView

Limiting a dimension range (set analysis ?)

Mon, 17 Jun 2013 14:07:34 GMT

Hi,

I am charting a metric by a date x-axis.

I am actually showing side by side two charts of the same metric - one by month resolution and another by days/weeks.

I want to limit the day resolution to only the last 60 days - no matter what is the date selection.

Can this be done ?

Thanks

Gur

Gysbert_Wassenaar — Mon, 17 Jun 2013 17:28:03 GMT

For the last 60 days leading up to the selected date:

sum({<MyDate={'>$(=max(MyDate)-60)<=$(=max(MyDate))'}>} Amount)

For the absolute last 60 days:

sum({<MyDate={'>$(=max({1}MyDate)-60)'}>} Amount)

Change MyDate and Amount with the name of your date field. Change sum and Amount to whatever you're trying to calculate.

Tue, 18 Jun 2013 07:12:29 GMT

Thanks Gysbert.

If I understand correctly, This is excellent for calculating a specific value. Thats great. Thanks

My big problem now is that I want to chart a value (metric) on a line chart.

The x-axis is of type date.

But I want to limit the dates to show only the last 90 days, no matter whats the selection. Limiting the dimension.

Can this be done ?

Thanks