Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Selection range in Set Analysis

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.

1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

2 Replies
jagan
Partner - Champion III
Partner - Champion III

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.

Not applicable
Author

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