topic Re: Logical help in QlikView

Logical help

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

Hi All,

I want to create a new column (TXT_EXPORT.ARGUMENT_05).Pls see the script and i have applied if condition

if(Num(TXT_EXPORT.ARGUMENT_051) > 10, TW_SP_BO.Reservoir_Pressure, "1*") as TXT_EXPORT.ARGUMENT_05

but it is not giving desired numerical result of TW_SP_BO.Reservoir_Pressure instead giving some string

Any one pls help me .I have reduced the data sorry 4 dat pls refer the screenshot it is hows is the data

Re: Logical help

prieper — Wed, 13 Sep 2017 13:30:02 GMT

Is it necessary to post a 36M attachment?

Use a "Straight Table" and enter an expression like

IF([Item 10] > 10 AND [Item 5] > 10, TW_SP_BO.Reservoir_Pressure, '1*')

Peter

Re: Logical help

sunny_talwar — Wed, 13 Sep 2017 13:31:29 GMT

But Item 5 and Item 10 are never greater than 10?

Re: Logical help

Anonymous — Wed, 13 Sep 2017 13:37:24 GMT

Hi Sunny ,

I have reduced the data

Re: Logical help

sunny_talwar — Wed, 13 Sep 2017 13:42:09 GMT

Can you reduce your file in such a way that we can see few of the rows where these numbers show up?

Re: Logical help

sunny_talwar — Wed, 13 Sep 2017 14:28:58 GMT

Got it.... so I see this script

Temp:

Load if( num(TXT_EXPORT.ARGUMENT_05) > 10, "TW_SP_BO.Reservoir_Pressure",'1*') as TXT_EXPORT.ARGUMENT_015

Resident TXT_EXPORT;

You are creating a new field called TXT_EXPORT.ARGUMENT_015... but I don't even see it in the application... TXT_EXPORT.ARGUMENT_05 isn't changing, but it is used to create a new field... is this what are hoping to do?

Re: Logical help

Anonymous — Wed, 13 Sep 2017 15:34:57 GMT

It is used to create a new field. ..any other suggestions

Re: Logical help

Anonymous — Wed, 13 Sep 2017 15:39:35 GMT

Exactly sunny any other ways to do so..

Re: Logical help

sunny_talwar — Wed, 13 Sep 2017 15:41:48 GMT

May be change it in the same table

TXT_EXPORT:

LOAD

if( num(TXT_EXPORT.ARGUMENT_05) > 10, "TW_SP_BO.Reservoir_Pressure",'1*') as TXT_EXPORT.ARGUMENT_05,

.....

FROM...

Re: Logical help

vvira1316 — Thu, 14 Sep 2017 15:40:33 GMT

We all here help each other. I've received lot of "Prompt and correct" help from users that are at top level and particularly from Sunny. He has been very prompt, tries to understand the problem we have and provides solution that has worked almost every time I've posted a question.

Re: Logical help

Anonymous — Wed, 20 Sep 2017 00:49:43 GMT

Hello Adarsh,

Please take a moment to mark the helpful and correct answers on this thread. Sunny and other members took quite a bit of time to assist you.

I will also clean up a few of the unnecessary posts along with the one that is mildly insulting. Please refrain from personal insults in your threads. If you feel that another community member is not being helpful feel free to reach out to me or ext_aaq‌ (Jeremy Latimer) who is our global moderator for assistance.

We want to keep conversations within Qlik Community open and friendly.

Best Regards, Sara

Re: Logical help

Anonymous — Wed, 20 Sep 2017 14:26:08 GMT

Thanks Sara for your concern will take care of it and will mark answer as helpful

Re: Logical help

Anonymous — Wed, 20 Sep 2017 14:57:23 GMT

Thanks all for your continuous support and apolgy for hurting anyone my issue has been resolved .It was error in requirement.