topic Re: For repeated expression in 'n' of objects how can i write variable at edit script level in QlikView

For repeated expression in 'n' of objects how can i write variable at edit script level

Anonymous — Fri, 29 Nov 2013 09:10:28 GMT

Hi friends,

i have a repeated Expression in 'N' of objects.

How can i write variable at edit script level.

Below is the sample expression

COUNT(Distinct {<Phase={'Live'},Age={'>=0<=30'}>}SOW_CT).

The above expression we are going to using around 6 objects.

I know one method Settings---->Document Properties ---create variable---New etc....,

let me know your suggestion for reuse of expression from Edit script level

InAdvance

Thank you

Nicole-Smith — Tue, 03 Dec 2013 18:29:01 GMT

In the script, you use must use SET or LET to populate a variable:

SET Variable = 'COUNT(Distinct {<Phase={'Live'},Age={'>=0<=30'}>}SOW_CT)';

Then you can use the variable in your charts inside of dollar sign expansion:

$(Variable)

Tue, 03 Dec 2013 19:51:42 GMT

hi Anil,

you can go through this link for more understanding of variable as reusable code