Set Analysis with multiple variables for one field

PetterAhlin — Sat, 16 Nov 2024 19:04:10 GMT

//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

Re: Set Analysis with multiple variables for one field

sunny_talwar — Fri, 21 Feb 2020 13:28:32 GMT

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

Re: Set Analysis with multiple variables for one field

PetterAhlin — Fri, 21 Feb 2020 14:11:14 GMT

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

topic Re: Set Analysis with multiple variables for one field in QlikView

Set Analysis with multiple variables for one field

Re: Set Analysis with multiple variables for one field

Re: Set Analysis with multiple variables for one field