topic Re: Variable inside Set Analysis in QlikView

Variable inside Set Analysis

bkn — Sat, 16 Nov 2024 04:07:38 GMT

SET vMonth2019 = 2019

SET vStatus = IF($(vMonth2019 )='0','N','Y');

SUM({$<[Contion1]={'True'}, vStatus ={'Y'}"}>}$(vTotal))) // Need to use vStatus Variable inside expression.

Thanks in Advance !

Re: Variable inside Set Analysis

rubenmarin — Mon, 18 Mar 2019 18:53:15 GMT

Hi, I suppose you wnat to use the result of vStatus expression, for that it will need an extra '=':
SET vStatus = =IF($(vMonth2019 )='0','N','Y');

You can use it in set analysis as vMonth2019 is used in vStatus:
SUM({$<[Contion1]={'True'}, vStatus={'$(vStatus)'}"}>}$(vTotal))) // vStatus should be a field where you use the value of the vStatus variable

Re: Variable inside Set Analysis

bkn — Mon, 18 Mar 2019 19:17:42 GMT

SET vStatus = IF($(vMonth2019 )='0','N','Y');

SUM({$<[Contion1]={'True'}, vStatus={'$(vStatus)'}}>}$(vTotal)))

//Tried as you said, but its giving all the value vMonth2019 as 0.

Any other solution?

Re: Variable inside Set Analysis

Nagaraju_KCS — Tue, 19 Mar 2019 08:49:28 GMT

SUM({$<[Contion1]={'True'}, vStatus ={'Y'}"}>}$(vTotal))) which i have highlighted in RED that should be field.

You can write in script.

IF(Year=0, 'N', 'Y') as Field; or IF(Len(Year)=0, 'N', 'Y') as Field ; or IF(Len(Trim(Year))=0, 'N', 'Y') as Field ;

If you provide sample data that would be great, easy to understand.

Re: Variable inside Set Analysis

rubenmarin — Tue, 19 Mar 2019 10:26:34 GMT

In your example vMonth2019 has a fixed value of 2019:
SET vMonth2019 = 2019

BTW, your vStatus only hsa one '=', as I said you need 2.

My answer only explains how to use a variable inside set analysis, wich is the only question you have in your post, for a solution you need to explain what are you trying to do, and it will be easier for both of us if you upload a sample.