Set Analysis

Remco — Fri, 02 Apr 2021 08:07:59 GMT

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!

Re: Set Analysis

sunny_talwar — Tue, 01 Oct 2019 16:13:35 GMT

Try this

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

Re: Set Analysis

Remco — Tue, 01 Oct 2019 16:16:36 GMT

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

topic Set Analysis in App Development

Set Analysis

Re: Set Analysis

Re: Set Analysis