Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Set Analysis

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!

 

1 Solution

Accepted Solutions
Contributor III
Contributor III

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

View solution in original post

2 Replies

Try this

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

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

View solution in original post