topic Re: Bug QlikView & QlikSense !? in QlikView

Bug QlikView & QlikSense !?

lucpechali — Fri, 28 Sep 2018 13:31:03 GMT

Hi all,

I've found something very strange on both QV and QS, whatever script or GUI :

Try this :

if(70/100=0.7,'True','False')

It's false ??? How ???

then test this :

if(60/100=0.6,'True','False')

It's true !!! Really ?

Is anyone already found this ?

The only way to make it true it's like this :

if(num#(70/100)=0.7,'True','False')

Any explications ?

Thx

Frank_Hartmann — Fri, 28 Sep 2018 13:43:36 GMT

i guess the ratio is treated by QV as a string. you can also do like this:

=if($(=70/100)=0.7,'True','False')

Miguel_Angel_Baeyens — Fri, 28 Sep 2018 13:49:40 GMT

What Qlik Support has told you?

lucpechali — Wed, 03 Oct 2018 09:03:15 GMT

Hi ,

I've found this on the community. It seems to be the right answer