Set Analysis

[Luisanabria]

Hi all,

lm using set analysis in a graph expression:

if(Sum({<Year={$(=Max(Year))}>} Year<>'2023'),'NoData, Sum({<Year={$(=Max(Year))}>} [Sales Budget HQ]))

but l dont know what is wrong because in the next comparative, Set Analysis is adding January and February and puts in January . (22.63M)

 

Red is the wrong amount, amount should be 7.59M, maybe lm using an incorrect expression

I want something as next comparative:

lm using the same Set Analysis in both examples only changing the Year, because variables has the same name but in different App, but in the first is not working ok

Thanks in advance

[vinieme12 · Accepted solution]

This is correct : Sum({<Year={$(=Max(Year))}>} [Sales Budget HQ])   

This is INCORRECT : Sum({<Year={$(=Max(Year))}>} Year<>'2023' )

if you want to compare Jan 2022,Feb 2022  vs Jan 2023 ,Feb 2023 ,  do the below

1) Dimension : Use the Month field ; which has values Jan,Feb,Mar etc  AND NOT Month-Year

2) Add 2 Measures, one for 2023 and another for 2022

Latest Year(2023,Jan to Date)

= Sum({<Year={$(=Max(Year))}>} [Sales Budget HQ])   

Full  Year 2022(Jan to dec)

= Sum({<Year={$(=Max(Year)-1)}>} [Sales Budget HQ])   << this will return full year 2022

YTD 2022(2022, Jan to date)

= Sum({<Datefield={">=$(=YearStart(Max(Datefield),-1))<=$(=AddYears(Max(Datefield),-1))"}>} [Sales Budget HQ])

replace Datefield  with your actual date field name

[akatsushi]

Looking to see if Qlik can provide links to documents within an app. We use a cloud hosting service for documents. And one of our web pages we have made allows us to track documents, and pull from our document management service (dms). However, as we look to retire this website, we are hoping to include it within Qlik, but building out a document tracking app within Qlik pulling data from our database to get the stage of a file, and provide links from our dms.

Is this possible, and what would be the best way to go about it.

[Luisanabria]

Thank you Vinie

I was using Sum({<Year={$(=Max(Year))}>} Year<>'2023' ) but with If, but your solution was usefull. 

As always, thanks