Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mattg1958
New Contributor

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
MVP
MVP

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

Try this

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

mattg1958
New Contributor

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

Thank you.  That worked.

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

MVP
MVP

Re: Why didn't my field expression produce the expected 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?