QV12 Boolean not a dual?

[Michiel_QV_Fan]

Hi,

we are using True() and False() in scripting to create booleans.

According to the help text True() and False() create a dual but  after upgrading to QV12, version 12.40.20000.0 April 2019 I only get -1 or 0 where previously (, that is in QV11, )True and False were shown. 

The fields are used in a multibox.

If I add the field to a tablebox it also shows -1 and 0. Representation is set to Text.

Any thoughts?

Helptext: https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/MathC...

[marcus_sommer]

It might be a bug in this release or there were changes within your load-process so that those fields lost their dual-feature and only the numeric values was stored.

Maybe it's an alternatively to set this explicit with the dual-function: dual(true(), true())

- Marcus

[Michiel_QV_Fan]

Marcus, I tried that and it works. However, it doesn't make sense of course to dual a dual function. Moreover, this is used extensively throughout the qlikview so editing and maintaining this in case of a possible bug isn't the best way to go.

FYI:

one of the statements used:

if(isnull(PlannedDate), null(), if(isnull(ActualDate), false(), true())) as IsDelivered

results in -1 or 0 

Please review the attached png with results and basic settings.

[marcus_sommer]

Such change mustn't be so expensive as it at a first glance looked because it could be changed with the replace-feature triggered by CTRL + H. But of course you need to be carefully with it and only doing after ensuring that there are backups.

But before I think it would be sensible to check if there is really a bug or maybe a change in your load-logic or maybe an intentional processing-change in Qlik.

One very easy way would be to put true() within a textbox or a table and to look what happens. Another check would be to create a new qvw with a simple table and few records with true/false and true/false/null and dual(true/false) and dual(true/false/null) as columns and also storing them into a qvd. Then again checking the results within a textbox/table directly from the loaded table and then also dropping the table and loading the qvd once optimized and once non optimized (maybe enforced per where 1=1).

A further check could also be to look at the qvd's with a editor like notepad++. Is there any difference by a field if true/false are created implicitely/explicitely and also if the new ones differ to older ones (with QV 11 created) from you.

- Marcus

[Brett_Bleess]

Michiel, you are running the Initial Release version of 12.40, can you pull the SR1 release and check it?  If you still see the issue, leave a new post, and I can try to get R&D to have a look at things at that point, but I need to be sure the fix is not in SR1 first.  The Release Notes are not leading me to believe it will work any differently, but if you can verify, that would be great, or if you can attach a sample app with the issue, I should be able to use that to test myself, just want to be sure I do not screw things up here.

Regards,
Brett

[ClaireZ]

Hi there!

Have this issue been solved? Could you share how you solved it?

I'm having the same issue with .qvw that were built on version 12.10 while using them with version 12.40 (SR3).

Thanks,

Claire 

[Michiel_QV_Fan · Accepted solution]

https://support.qlik.com/articles/000063470

We have set some dual values to reset the 1 or 0 to Yes and No with the duals.

We have not yet upgraded to 12.40.