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: 
Not applicable

How do I use hyphen(-) values in conditions

Hi Everybody,

I have a field called STATUS_ARCHIVE in my data model.

It contains both these values 'false' & '-'(Hyphen).

Now in my expression, I need to include values for which STATUS_ARCHIVE='-'. But it won't work for some reason unknown to me.

I also tried this STATUS_ARCHIVE=STATUS_ARCHIVE-{'false'}, it doesn't work too. Also I tried to change the Null Symbol in Presentation

tab to 'Not' and then I tried to use STATUS_ARCHIVE={'Not'}, it doesn't work either.

I shall be grateful, if anyone came across such a situation and could please share it with me.

Thanks & Regards,

Bikash Debnath

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi Bikash,

I created a sample qvw using QV10 SR2 and set analysis.

Check it out and let me know.

Regards,

Fernando

Not applicable
Author

Thank You Fernandao, that really helped.