topic Re: VARIABLE IN SET ANALYSIS in App Development

VARIABLE IN SET ANALYSIS

Billy_u — Sat, 16 Nov 2024 03:46:30 GMT

Hi everyone,

i try in qlik sense a set analysis with a variable, i will want calcolate a misure of year and year preview, but make me the total:

sum({<ANNO = {$(=max(ANNO))}},=$(=$(varaiblemesaure)))

With this result a total of all year...

thx every one,

hi,

Billy

Re: VARIABLE IN SET ANALYSIS

Anil_Babu_Samineni — Thu, 19 Dec 2019 10:05:55 GMT

What is the "varaiblemesaure"?

Re: VARIABLE IN SET ANALYSIS

Billy_u — Thu, 19 Dec 2019 10:32:36 GMT

is a variable / container, where there is an expression whose result is a score

Re: VARIABLE IN SET ANALYSIS

Anil_Babu_Samineni — Thu, 19 Dec 2019 10:35:41 GMT

If that variable returns 1000, Simply use

sum({<ANNO = {"$(=max(ANNO))"}>} variablename)

sum({<ANNO = {"$(=max(ANNO))"}>} $(variablename))

Re: VARIABLE IN SET ANALYSIS

Billy_u — Thu, 19 Dec 2019 10:43:31 GMT

the problem is that it makes me the total sum, instead I would like the data of the year max or of the previous year, to compare them

Re: VARIABLE IN SET ANALYSIS

Anil_Babu_Samineni — Thu, 19 Dec 2019 10:49:57 GMT

The same question you already asked in the opening message itself. What is variable you defined? Is this something ANNO = {"$(=max(ANNO))"} calculating the Max Year? If not, What your goal here?

If you need compare analysis, Create Bar chart with Dimension as ANNO and Expression

Sum({<ANNO = {">=$(=AddYears(Max(ANNO),-1))<=$(=Max(ANNO))"}>} variablename)

Re: VARIABLE IN SET ANALYSIS

Billy_u — Thu, 19 Dec 2019 10:53:20 GMT

I would like to make the difference between the (variable) score of the current and previous year variable

Re: VARIABLE IN SET ANALYSIS

Anil_Babu_Samineni — Thu, 19 Dec 2019 10:54:52 GMT

Can u please upload an example to test?

Re: VARIABLE IN SET ANALYSIS

Billy_u — Thu, 19 Dec 2019 11:19:22 GMT

the result if i will want it's:

something similar...

($(score(MaxYear)) - $(score(MaxYear-1))) / $(score(MaxYear-1))

Re: VARIABLE IN SET ANALYSIS

Anil_Babu_Samineni — Thu, 19 Dec 2019 11:26:47 GMT

Seems like this is like Parameter query in analysis? I believe you already have variable like score in that you want by pass the all values with Latest and Latest-1?