topic Re: not getting numerical value in QlikView

not getting numerical value

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

Hi all,

This is the requirement .In the attached qvw in the table if the value of Item 10 and Item 5 is greater than 10, then it would display the value of other field TW_SP_BO.Reservoir_Pressure otherwise display "1*"

Can anyone help me??

Regards

Adarsh

Re: not getting numerical value

sunny_talwar — Tue, 12 Sep 2017 18:16:08 GMT

Try without double quotes

if(X>10,Y,1)

Re: not getting numerical value

its_anandrjs — Tue, 12 Sep 2017 18:23:05 GMT

In your environment you can cross check this condition

create a variable

Let X = 110;

Let Y = 'Hello';

=if( X > 10, Y , 1)

This can be used in your app also

=if( X > 10, Y , 1)

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 18:27:43 GMT

First condition is not getting satisfied that is values of Y is not getting displayed

Re: not getting numerical value

its_anandrjs — Tue, 12 Sep 2017 18:33:36 GMT

Y is a field or what can you share some sample data it is easy to help.

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 19:14:02 GMT

hi Anand,

Its like 0.1,02,03 up 10000 and decimals

Re: not getting numerical value

ziadm — Tue, 12 Sep 2017 19:17:42 GMT

go to setting --Variables overview and remove the variable if it still in the list

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 19:19:08 GMT

which variable???ziad??

Re: not getting numerical value

sunny_talwar — Tue, 12 Sep 2017 19:19:36 GMT

adarsh1612‌ my friend, I don't want to sound rude, but the way you have been putting out your requirement... I don't think you will have an easy time finding answers.... You need to look at these threads

How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling‌

Uploading a Sample

Also, you have not been a very responsible citizen of this Community where you keep on creating multiple threads for the same issue just because you are not getting answers to any of them. On top of it you don't even want to close any of the threads you create?

If you want to continue doing this, I am def. not going to look at your posts in the future because I know that

1) This guy doesn't post enough info for me to answer

2) Will never close a thread

So, I request you to help me help you better by following all/some of the things I have mentioned above.

Thanks,

Sunny

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 19:38:13 GMT

Sure Sunny i will follow the points you told

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 19:41:52 GMT

Yes i will not create multiple threads but how can you expect me to close a thread if i am not getting right answer

Re: not getting numerical value

sunny_talwar — Tue, 12 Sep 2017 19:52:39 GMT

I don't expect to close a thread if you have not gotten an answer, but I am expecting you to provide relevant information/Sample/Raw data so that we can help you resolve your issue.... like this, I don't even think you will get anything resolved ever.

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 20:07:44 GMT

Fine got it........next on wards will provide the raw date as well

Re: not getting numerical value

sunny_talwar — Tue, 12 Sep 2017 20:46:28 GMT

Why next time? You don't want the solution for this problem anymore

Re: not getting numerical value

Anonymous — Tue, 12 Sep 2017 20:51:26 GMT

I want but as if now I m not in office I will share raw data tomorrow for sure hoping a help from u

Re: not getting numerical value

sunny_talwar — Tue, 12 Sep 2017 20:52:29 GMT

For sure

Re: not getting numerical value

Clever_Anjos — Wed, 13 Sep 2017 16:40:26 GMT

Same issue from here?Logical help

You are not supposed to post the same issue twice