Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
adarsh1612
Creator
Creator

Logical help

Hi all,

Pfa the two qvw files we are using model qvw as a binary load in second qvw .Now we have a requirement like this.:

Target / Subject Requirement

Description of the requirement

BHP should be included for the Keywords WCONHIST and WCONINJH

Solution (optional)

For more extensive Problems please refer "Requirement catalog".

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*”

Thanks in advance.Its very urgent

Message was edited by: adarsh chaubey

6 Replies
vinieme12
Champion II
Champion II

use the Keep Keyword to reduce the data from your table after the binary load

Refer the below post

Understanding Join, Keep and Concatenate

example

Binary load   xxxxxxx;

inner keep(TableName)

Load * INline [

BHP

WCONHIST

WCONINJH

];

adarsh1612
Creator
Creator
Author

Hi Vineeth,

Can you pls explain it more in qvw??

Would be grateful to you.

Regards

Adarsh

vinieme12
Champion II
Champion II

After this line add the below script

Binary [..\model\model - txt_export.qvw];


inner keep(TableName)    //<< Update the table name in the brackets

Load * INline [

BHP           // << The Fieldname by which you want the reduce the data in the table

WCONHIST

WCONINJH

];

adarsh1612
Creator
Creator
Author

the only issue i am getting here is the name of table and also what  about this  requirement:

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*”


Thanks Vineeth in advance

adarsh1612
Creator
Creator
Author

Anyone its very urgent???I am not able to get the real requirement

adarsh1612
Creator
Creator
Author

@

Irena Calovska