Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
PetterAhlin
Partner
Partner

Set Analysis with multiple variables for one field

//I have two variables assigned with YearMonth values in the load script.
vL.LastMonth //e.g. 202003
vL.StartMonth //e.g. 202001 or 202004
 
I have a set analysis in an expression in a straight table chart. The set analysis is used to make sure the record I extract in the Only function is of last month but not earlier than given start month. I tried the different values in StartMonth to check if the set analysis works as I expected. A value should be returned for TargetField when assigning 202001 to vL.StartMonth. No value should be returned if 202004 is assigned to the variable.
 
The following set analysis does NOT work for intended purpose:
=Only({1<YearMonthField={"=$(vL.LastMonth) >=$(vL.StartMonth)"}>} TargetField)
 
However, if I define the set analysis the following way (with two instances of same field name) it works fine:
=Only({1<YearMonthField={"=$(vL.LastMonth)"}, YearMonthField={">=$(vL.StartMonth)"}>} TargetField)

I probably do some simple error, but can't understand what causes the first Set Analysis above to fail.
 
Kindly, Petter Ahlin
1 Solution

Accepted Solutions
PetterAhlin
Partner
Partner

Thank you for your reply. The case can be closed. It was a matter of a mistake I made expecting the data to be different than it actually was. This post can be closed and deleted, thank you.

Kind regards,

Petter

View solution in original post

2 Replies
sunny_talwar

What exactly is your condition here? I am not sure what exactly are you trying to do?

PetterAhlin
Partner
Partner

Thank you for your reply. The case can be closed. It was a matter of a mistake I made expecting the data to be different than it actually was. This post can be closed and deleted, thank you.

Kind regards,

Petter

View solution in original post