topic Re: QV12 Boolean not a dual? in QlikView

QV12 Boolean not a dual?

Michiel_QV_Fan — Sat, 16 Nov 2024 20:11:28 GMT

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/MathConstantsAndParamFreeFunctions/mathematical-functions.htm?id=809#True

Re: QV12 Boolean not a dual?

marcus_sommer — Wed, 28 Aug 2019 07:46:41 GMT

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

Re: QV12 Boolean not a dual?

Michiel_QV_Fan — Wed, 28 Aug 2019 08:19:15 GMT

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.

Re: QV12 Boolean not a dual?

marcus_sommer — Wed, 28 Aug 2019 09:26:40 GMT

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

Re: QV12 Boolean not a dual?

Brett_Bleess — Thu, 05 Sep 2019 17:42:20 GMT

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

Re: QV12 Boolean not a dual?

ClaireZ — Thu, 05 Mar 2020 23:51:08 GMT

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

Re: QV12 Boolean not a dual?

Michiel_QV_Fan — Fri, 06 Mar 2020 08:28:19 GMT

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.