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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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.