topic Re: Selection range in Set Analysis in QlikView

Selection range in Set Analysis

Fri, 01 Mar 2013 04:24:09 GMT

Hi,

I'm wanting to know whether you can use selection range in set analysis.

What I'm trying to do is:

A user filters the report date to be 01/03/2013 (this could vary).

However for 1 of my graphs, I want it to display data from a fixed start date (01/07/2006) and the current user selection date.

Is this possible?

Thanks in advanced.

jagan — Fri, 01 Mar 2013 06:33:30 GMT

Hi,

You can do this by using set analysis

Create a variable with

vSelectedDate = Max(DateDimension)

=Sum({<DateDimension={">=$(Date('01/07/2006'))<=$(=vSelectedDate)"}>} Sales)

Hope this helps you.

Regards,

Jagan.

Mon, 04 Mar 2013 02:54:36 GMT

Thanks Jagan, that's exactly what I was after.