topic Re: variable and set analysis in QlikView

variable and set analysis

Mon, 26 Jan 2026 18:19:17 GMT

HI all

I've a problem with variable and set analysis.

I've this expression : =sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

because I have to use it in many analyzes, I would put the set analalysis formula in a variable then i created a variable

V_var=sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

and then i used it in a colum table but it did not work.

the question is: is it possible put in a variable a whole set analysis expression??

thanks for your help

sunny_talwar — Sat, 26 Sep 2015 12:23:12 GMT

Couple of questions:

When you use the expression in a straight table does it give you your desired output?
Are you using V_var as the expression or $(V_var)? Try using $(V_var), if you are not.

the question is: is it possible put in a variable a whole set analysis expression??

To answer the above question -> Yes you can save a whole set analysis expression in a variable.

swuehl — Sat, 26 Sep 2015 12:58:53 GMT

It seems that you put the whole expression into a variable, not only the set analysis part.

You should be able to do both, but you may need to take care of the way you defined your variable:

maxgro — Sat, 26 Sep 2015 13:04:01 GMT

yes it's possible

see attachment

Sat, 26 Sep 2015 16:14:14 GMT

thanks for your help.

i tried to use $var but it did not work. this is the new outcome:

V_EMESSO_P_GI is =sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )

AREA	2015	2014	208390661,80896
italy	829,201	42,966	0
england	3,382,028	41,259,523	0
austria	28,225	87,062	0
germany	93,376	1,861,027	0


	=sum( {$<ANNO = {$(=Only(ANNO))}>} EMESSO_P_GI )	=sum( {$<ANNO = {$(=Only(ANNO-1))}>} EMESSO_P_GI )	$(V_EMESSO_P_GI)

maybe it could be a var scope issue, it seems that the Variable does not recognize the dimension level (Area).

i really appreciate your help

ciao

Sat, 26 Sep 2015 17:11:37 GMT

the soluions was:

I was wrong variable's syntax

thanks for help

ciao