Logical help

[Anonymous]

Hi all,

I have attached the image ,we have a requirement as follows:

1.BHP (Bottom hole pressure) should be included for the Keywords WCONHIST and WCONINJH

For each stated keyword the BHP should be included in the table.

WCONHIST – Item 10* = BHP

WCONINJH – Item 5* = BHP

The following condition shall be used:

  The BHP shall be included only if the value is defined and above a threshold value of 10. Otherwise it shall be stated as “1*”*”.

Any help will be highly appreciated.

Regards

Adarsh

[Anonymous]

Any one ???? Any help is highly appreciated

[Anil_Babu_Samineni]

I am sorry, In script, I didn't see name called BHP. What does exact mean here

1) Load * From Table Where BHP Like 'WCONHIST';

OR

Load * From Table Where BHP = 'WCONHIST';

2) Load *, WCONHIST - (Item * 10) as BHP

3) If(Value > 10, BHP, '1*')

[qliksus]

Your requirement is not clear can you explain more on what you need ?

[jonathandienst]

I suggest you add sample input data together with your required results. Also

Qlik Community Tip: Posting Successful Discussion Threads

Qlik Community Tip: How to Get Answers to Your Post

Preparing examples for Upload - Reduction and Data Scrambling

[avinashelite]

Could you share the sample data with the required output ? so that we could help you

[Anonymous]

Hi Anil,

I have edited the requirement pls have a look and suggest.

[Anonymous]

Hi Avinash,

I have edited the requirement pls have a look and suggest.

[avinashelite]

What is the input data? how is this 2 columns are related ? how to calculate the threshold value

[Anonymous]

HI AVINASH ,

I am creating a fresh post with qvw ..pls have a look

Regards