topic Re: Logical issue in QlikView

Logical issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I have a requirement where if value of field X is greater than 10 then it should be replaced by values of other field Y.Otherwise show value as 1.I am applying a logic

if(X>10,Y,"1")

But it is not giving the values of Y For values greater than 10 instead giving a string "PRAGNOS

Can anyone help me??

Regards

Adarsh

Message was edited by: adarsh chaubey

Re: Logical issue

prieper — Tue, 12 Sep 2017 14:34:46 GMT

in script or expression?

can you please post an example?

Re: Logical issue

Anonymous — Tue, 12 Sep 2017 14:51:52 GMT

Hi peter pls see the below image

Re: Logical issue

prieper — Wed, 13 Sep 2017 08:24:19 GMT

Would recommend to check the content of the field BHP.

Why do you choose NUM#(TXT_EXPORT.ARGUMENT_13) or NUM(BHP)? In most cases QV does not really differentiate betw strings and numbers.

Might be worth to have a tablebox with the inputvalues and the output and check for anomalies in the in input-data.

Peter