topic Re: Variable and Set analysis in QlikView

Variable and Set analysis

alec1982 — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

trying to set a variable with the following expression

Set vYFactor = if(GetSelectedCount([X_Factor.Location])=0, only({<[X_Factor.Location]={"=$(vAverage)"}>}[X_Factor.Storage Paid]), only([X_Factor.Storage Paid]);

when I try to present it in a text box I dont get any value

any idea?

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 16:32:23 GMT

Are you doing this in the script?

You might need to replace $ with something else (#) before and replace # with $ again in the script:

SET vYFactor = Replace('If(GetSelectedCount([X_Factor.Location])=0, only({<[X_Factor.Location]={"=#(vAverage)"}>}[X_Factor.Storage Paid]), only([X_Factor.Storage Paid])', '#', '$');

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 16:42:04 GMT

thank you Sunny..

here is how my two variables looks like now on the script:

set vAverage= '=Average';

SET vYFactor = Replace('If(GetSelectedCount([X_Factor.Location])=0, only({<[X_Factor.Location]={"=#(vAverage)"}>}[X_Factor.Storage Paid]), only([X_Factor.Storage Paid])', '#', '$');

do they look right to you?

Also what should i use inside the text box?

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 16:44:54 GMT

To tell you the truth, I know $() in script variables give problem because they get evaluated. So replace is the solution to get around that, but I have never tried it on my own. I have seen Stefan providing solution to this on various occasions, let me see if I can find one of his responses.

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 16:46:33 GMT

Here check this out:

Re: Expression as a variable with $-sign expansion

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 16:48:44 GMT

So try something like this instead:

LET vYFactor = 'If(GetSelectedCount([X_Factor.Location])=0, only({<[X_Factor.Location]={"=$' & '#(vAverage)"}>}[X_Factor.Storage Paid]), only([X_Factor.Storage Paid])', '#', '$')';

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 16:59:35 GMT

i think your solution is fine. the only issue on it is the value inside the set analysis to be 'Average'...

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 17:05:26 GMT

but not sure how I can do that...

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 17:06:30 GMT

What is the Average used for?

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 17:21:47 GMT

just want to pass the value which is 'Average' in set analysis

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 17:22:54 GMT

the last expression you sent has errors in it

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 17:28:01 GMT

Yup forgot to remove the end part

LET vYFactor = 'If(GetSelectedCount([X_Factor.Location])=0, Only({<[X_Factor.Location]={"=$' & '#(vAverage)"}>}[X_Factor.Storage Paid]), Only([X_Factor.Storage Paid]))';

Re: Variable and Set analysis

alec1982 — Fri, 08 Jul 2016 17:45:15 GMT

i still see extra # on it

Re: Variable and Set analysis

sunny_talwar — Fri, 08 Jul 2016 18:13:27 GMT

LET vYFactor = 'If(GetSelectedCount([X_Factor.Location])=0, Only({<[X_Factor.Location]={"=$' & '(vAverage)"}>}[X_Factor.Storage Paid]), Only([X_Factor.Storage Paid]))';