Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
adarsh1612
Creator
Creator

not getting numerical value

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

16 Replies
sunny_talwar

Try without double quotes

if(X>10,Y,1)

its_anandrjs

In your environment you can cross check this condition

create a variable

Let X = 110;

Let Y = 'Hello';

=if( X > 10, Y , 1)


Or


This can be used in your app also


=if( X > 10, Y , 1)



adarsh1612
Creator
Creator
Author

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

its_anandrjs

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

adarsh1612
Creator
Creator
Author

hi Anand,

Its like 0.1,02,03 up 10000 and decimals

ziadm
Specialist
Specialist

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

adarsh1612
Creator
Creator
Author

which variable???ziad??

sunny_talwar

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?

Capture.PNG

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

adarsh1612
Creator
Creator
Author

Sure      Sunny i will follow the points you told