topic Re: Can't get the new outer set analysis syntax to work in App Development

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

qlikster — Sat, 11 Nov 2023 18:40:14 GMT

Hi,

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

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

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

hic — Sat, 11 Nov 2023 18:56:58 GMT

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

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

qlikster — Sat, 11 Nov 2023 19:37:21 GMT

Thanks Henric!

That did it 🙂

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