
Not applicable
2014-05-29
03:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- new_to_qlikview
342 Views
1 Reply

Partner - Specialist
2014-05-29
03:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
191 Views
