topic Re: Logical issue in QlikView

Logical issue

Anonymous — Tue, 12 Sep 2017 14:32:56 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

Re: Logical issue

marcelviegas — Tue, 12 Sep 2017 19:41:07 GMT

Is your logic right, can you post an example?

Re: Logical issue

Anonymous — Tue, 12 Sep 2017 19:48:18 GMT

pls see the image Marcel

Re: Logical issue

marcelviegas — Tue, 12 Sep 2017 20:41:46 GMT

check if it TXT_EXPORT.ARGUMENT_13 this is a valid number

Re: Logical issue

Anonymous — Tue, 12 Sep 2017 20:48:28 GMT

Hi Marcel it is a field, if the value of this field is greater than 10 then we have to replace by the value of other field BHP other wise show 1

Re: Logical issue

Anonymous — Tue, 12 Sep 2017 20:50:45 GMT

Try this :

In script,

Load

num#(TXT_EXPORT.ARGUMENT_13) as TestArguement;

num#(TXT_EXPORT.ARGUMENT_13,'###') as TestArguement2;

In App

bring them in as objects. (Pls. Paste the results or any sample data on what you are trying to accomplish)

Thanks,

Re: Logical issue

Anonymous — Tue, 12 Sep 2017 20:52:47 GMT

Thanks SP will share raw date tomorrow thanks a lot