Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Why didn't my field expression produce the expected result?

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},

 

 

3 Replies
sunny_talwar

Try this

[QUEUE_DATA.DURATION]={">0<3"}

Anonymous
Not applicable
Author

Thank you.  That worked.

I'd still like to understand what the original syntax means such that it didn't produce the desired result.

sunny_talwar

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?