Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?