Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikster
Contributor III
Contributor III

Can't get the new outer set analysis syntax to work

Hi,

I'm struggling with getting the new outer set analysis syntax to work.

https://community.qlik.com/t5/Design/New-Set-Analysis-syntax/ba-p/1983110

 

This doesn't work, I'm still only getting the current year. 

{$<Year={$(=Max(Year)-1)}>}
count( {$<EXAMBOOKINGSTATUS={Booked}>} BOOKINGCOUNTER)
/
count( {$<EXAMBOOKINGSTATUS=-{Blocked}>} BOOKINGCOUNTER)

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Try removing the dollar signs. I.e. use this instead:

{$<Year={$(=Max(Year)-1)}>}
count( {<EXAMBOOKINGSTATUS={Booked}>} BOOKINGCOUNTER)
/
count( {<EXAMBOOKINGSTATUS=-{Blocked}>} BOOKINGCOUNTER)

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Try removing the dollar signs. I.e. use this instead:

{$<Year={$(=Max(Year)-1)}>}
count( {<EXAMBOOKINGSTATUS={Booked}>} BOOKINGCOUNTER)
/
count( {<EXAMBOOKINGSTATUS=-{Blocked}>} BOOKINGCOUNTER)

qlikster
Contributor III
Contributor III
Author

Thanks Henric! 

That did it 🙂

So the dollar sign makes the following calculations in to an inside element calculation?