topic Re: Piece of set analysis in a variable ? in QlikView

Piece of set analysis in a variable ?

Wed, 24 Sep 2014 11:46:34 GMT

Hello everyone,

In an application, I often use a piece of code in a set analysis which is quite long. is there a way to store it in kind of a variable so I don't have to write it each time ?

Thank you

Laura

Re: Piece of set analysis in a variable ?

Gysbert_Wassenaar — Wed, 24 Sep 2014 11:54:42 GMT

Yes, that's a very good idea. Here's an example:

original:

expression: sum({<FieldA={'Something'},FieldB={'>100'}>+<FieldC={'=sum(Sales)<1000'}>}Sales)

using a variable:

variable: vSetMod: {<FieldA={'Something'},FieldB={'>100'}>+<FieldC={'=sum(Sales)<1000'}>}

expression: sum( $(vSetMod) Sales)

You can of course also store parts the complete set modifier into different variables and combine those in the expression or in yet another variable. Variables can even take parameters:

vSetMod: {<FieldA={$1}>)

sum( $(vSetmod('Something')) Sales)

Re: Piece of set analysis in a variable ?

datanibbler — Wed, 24 Sep 2014 11:56:45 GMT

Hi Laura,

in principle, that is possible, no problem. You can use variables in a set_analysis - I have tried only with "simple" numeric values which don't require that expansion thingy, but I guess it should be possible with those, too.

HTH

Best regards,

DataNibbler

Re: Piece of set analysis in a variable ?

Wed, 24 Sep 2014 12:00:56 GMT

thank you Gysbert

Have a good day !