Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Alternate way to approach this situation

Hello Friends

I have a scenario

I want to capture values in a variable and then use that variable in my set analysis.

Below is the scenario

Currently I have a variable DateToSubscribe which holds all possible values of [Last Subscribed Days]

Currently it uses p() function to hold the values

Requirement: My requirement is if DateToSubscribe=6  then I want 0,1,2,3,4,5,6 as the values to return (set analysis preferred)



1 Reply

Not sure if I am understanding your requirement, but perhaps something like:

=Sum({<[Last Subscribed Days] = {"<=$(=Max([Last Subscribed Days]))"}>} ....)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein