Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm new to Qlik Sense and don't understand the syntax well.
I change a data measure expression because it didn't produce accurate results. But, I don't know why the first expression didn't work. Can someone explain why?
// Removed the following two line as they produced incorrect results.
//[QUEUE_DATA.DURATION]={'<3'},
//[QUEUE_DATA.DURATION]={'>0'},
// ... Replaced the prior two expressions with the following one.
[QUEUE_DATA.DURATION]={1,2},
Try this
[QUEUE_DATA.DURATION]={">0<3"}
Thank you. That worked.
I'd still like to understand what the original syntax means such that it didn't produce the desired result.
Within set analysis a single field can be used only once... when you used this
[QUEUE_DATA.DURATION]={'<3'}, [QUEUE_DATA.DURATION]={'>0'},
only green part was recognized and red was ignored... you can do this like this
{<[QUEUE_DATA.DURATION]={'<3'}>+<[QUEUE_DATA.DURATION]={'>0'}>}
Breaking it down into two different sets union-ed together
Does this make sense?