Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Knowledge
Match() function behaves differently in QV12.10 and up then it did QV11.20
Article Number: 000054175 | Last Modified: 2018/07/29Description
For example if you match 00, 01, 02, 03... with 0,1,2,3...
In 11.20 it will return true
Since 12.10 it will return false.
Environments:
In 11.20 it will return true
Since 12.10 it will return false.
Environments:
- QlikView 12.10 and up
- Qlik Sense 3.2 and up
Resolution
This is working as designed. Match compares strings, in this case it converts the numerical value to a string.
In 11.20 this was done without any respect to the format, resulting in the value 1.
In 12.20 the format of the field (REAL) is taken into consideration, using the format string "00" which results in the seen value, 01 for example. And the string comparison of 01 vs 1 is as expected false.
Get Answers
Find Answers
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us