Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any one ???? Any help is highly appreciated
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*')
Your requirement is not clear can you explain more on what you need ?
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
Could you share the sample data with the required output ? so that we could help you
Hi Anil,
I have edited the requirement pls have a look and suggest.
Hi Avinash,
I have edited the requirement pls have a look and suggest.
What is the input data? how is this 2 columns are related ? how to calculate the threshold value
HI AVINASH ,
I am creating a fresh post with qvw ..pls have a look
Regards