Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

comparison of field with string and Number - Count = 1 or Count = '1' ?


Hi,

I have below question.

I am new to qlikview.

is there any difference in qlikview,

if we put 1 as '1' OR 1 ???

is there any difference in qlikview,

if we filter fields with below

Count = 1 OR

Count = '1' ?   <----what is difference if we put number in double quote or without quote ?

thanks in advance.

1 Reply
julian_rodriguez
Partner - Specialist
Partner - Specialist

Hello,

There is not difference at all. You should use the symbol ', when the string contains special characters (a blank space for example)

So, Count(Field = 1) or Count(Field ='1') should result be the same.

Regards