topic Re: Logical help in QlikView

Logical help

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

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

Re: Logical help

Anonymous — Mon, 04 Sep 2017 18:02:17 GMT

Any one ???? Any help is highly appreciated

Re: Logical help

Anil_Babu_Samineni — Mon, 04 Sep 2017 22:29:02 GMT

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';

Load * From Table Where BHP = 'WCONHIST';

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

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

Re: Logical help

qliksus — Tue, 05 Sep 2017 05:04:08 GMT

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

Re: Logical help

jonathandienst — Tue, 05 Sep 2017 05:11:44 GMT

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

Re: Logical help

avinashelite — Tue, 05 Sep 2017 05:33:36 GMT

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

Re: Logical help

Anonymous — Tue, 05 Sep 2017 06:56:02 GMT

Hi Anil,

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

Re: Logical help

Anonymous — Tue, 05 Sep 2017 06:56:35 GMT

Hi Avinash,

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

Re: Logical help

avinashelite — Tue, 05 Sep 2017 07:25:58 GMT

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

Re: Logical help

Anonymous — Tue, 05 Sep 2017 12:53:47 GMT

HI AVINASH ,

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

Regards

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:05:02 GMT

Logical help

Hi Can you help me in this.

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:05:41 GMT

Hi Anil,

Can you help me in this.

Logical help

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:06:02 GMT

Hi Honathan,

Can you help me in this.

Logical help

Re: Logical help

jonathandienst — Thu, 07 Sep 2017 06:32:00 GMT

I would be happy to assist, but I do not yet understand your requirements. Did you read the suggestions that I posted earlier.