Set Analysis

[Remco]

Hello all!

I am new to Qlik so please be gentle with me 🙂 

I am trying to understand the set analysis and I saw a couple of thousand videos already about it. However, I am stuck to what I think should be quite easy. The next example works:

='RV Percentage ' & 100 * AVG({$<TYPE = {"AVG RV PERC"},PORTFOLIOPERIOD = {201908}>}ACTUAL)

It returns the percentage belonging to type AVG RV PERC where the PORTFOLIOPERIOD = 201908. There is a bar chart that shows all the percentages from different PORTFOLIOPERIOD and in the titel I want to have the average percentage belonging to the last (highest) PORTFOLIOPERIOD.

But when I change the 201908 into MAX(PORTFOLIOPERIOD) it does not work.  also tried the next:

AVG({$<TYPE = {"AVG RV PERC"},PORTFOLIOPERIOD = {'$=MAX(PORTFOLIOPERIOD)'}>}ACTUAL) 

but that stays blank. What am I doing wrong?

Thanks!

[sunny_talwar]

Try this

Avg({<TYPE = {"AVG RV PERC"}, PORTFOLIOPERIOD = {"$(=MAX(PORTFOLIOPERIOD))"}>} ACTUAL) 

[Remco · Accepted solution]

It worked... Just some stupid brackets... Thanks a lot. To be continued!