-
Re: Dual - Single Versus Double Quotes
Chanty 4u Apr 6, 2018 4:17 PM (in response to Justin McPheeters)-
Re: Dual - Single Versus Double Quotes
Justin McPheeters Apr 6, 2018 4:24 PM (in response to Chanty 4u)Thanks for the information. What Henric describes in your link is what I mentioned in my first paragraph. I know and understand the updates that were made, but in his post there is no reference to how the fix affected Dual() values.
It seems as though the fix to make single/double quotes work properly has possibly created another bug when you're doing set analysis with Dual() values.
-
Re: Dual - Single Versus Double Quotes
Marcus Sommer Apr 9, 2018 3:42 AM (in response to Justin McPheeters)I'm not sure if I would call it a bug especially because I'm don't on the current releases and couldn't test this behaviour. But I think you could bypass your problem by using a search-expression for it like:
... Field = {"=match(Field, 'Value')"} ...
- Marcus
-
Re: Dual - Single Versus Double Quotes
Justin McPheeters Apr 9, 2018 12:08 PM (in response to Marcus Sommer )Hi Marcus,
Writing the formula as you described does indeed work. Thank you for the workaround for those who need it!
I'll wait to see if Qlik/Henric can provide an update as to whether it should be required to treat Dual() values in a different way or if there can be an update/fix that will allow Dual() values to work as normal text values do.
Best regards,
Justin
-
-
-
-
Re: Dual - Single Versus Double Quotes
Henric Cronström Apr 9, 2018 5:08 AM (in response to Justin McPheeters)I will take a look at it.
HIC
-
Re: Dual - Single Versus Double Quotes
Justin McPheeters Apr 9, 2018 12:09 PM (in response to Henric Cronström )Thank you very much, Henric!
-
Re: Dual - Single Versus Double Quotes
Henric Cronström Apr 10, 2018 7:30 AM (in response to Justin McPheeters)Having looked at it briefly, I'd say it's a bug. It should compare the string with the textual value of the dual, but for some reason there is no match.
Meanwhile, I suggest you use Marcus' work-around. It should work.
HIC
-
Re: Dual - Single Versus Double Quotes
Justin McPheeters Apr 10, 2018 9:39 AM (in response to Henric Cronström )Perfect, thanks for the confirmation, Henric! Can't wait to see the fix in some future update!
-
-
-