Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Try removing the dollar signs. I.e. use this instead:
{$<Year={$(=Max(Year)-1)}>}
count( {<EXAMBOOKINGSTATUS={Booked}>} BOOKINGCOUNTER)
/
count( {<EXAMBOOKINGSTATUS=-{Blocked}>} BOOKINGCOUNTER)
Try removing the dollar signs. I.e. use this instead:
{$<Year={$(=Max(Year)-1)}>}
count( {<EXAMBOOKINGSTATUS={Booked}>} BOOKINGCOUNTER)
/
count( {<EXAMBOOKINGSTATUS=-{Blocked}>} BOOKINGCOUNTER)
Thanks Henric!
That did it 🙂
So the dollar sign makes the following calculations in to an inside element calculation?