Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
Valued Contributor II

Re: How do I use hyphen(-) values in conditions

Hi Bikash,

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

Check it out and let me know.

Regards,

Fernando

Not applicable

How do I use hyphen(-) values in conditions

Thank You Fernandao, that really helped.

Community Browser