
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
VARIABLE IN SET ANALYSIS
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What is the "varaiblemesaure"?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
is a variable / container, where there is an expression whose result is a score
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If that variable returns 1000, Simply use
sum({<ANNO = {"$(=max(ANNO))"}>} variablename)
Or
sum({<ANNO = {"$(=max(ANNO))"}>} $(variablename))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I would like to make the difference between the (variable) score of the current and previous year variable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can u please upload an example to test?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
the result if i will want it's:
something similar...
($(score(MaxYear)) - $(score(MaxYear-1))) / $(score(MaxYear-1))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
