topic Re: Logical help in QlikView

Logical help

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

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

Re: Logical help

vinieme12 — Tue, 05 Sep 2017 13:05:20 GMT

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

];

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:15:19 GMT

Hi Vineeth,

Can you pls explain it more in qvw??

Would be grateful to you.

Regards

Adarsh

Re: Logical help

vinieme12 — Tue, 05 Sep 2017 13:25:09 GMT

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

];

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:31:10 GMT

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

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:45:32 GMT

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

Re: Logical help

Anonymous — Tue, 05 Sep 2017 13:54:51 GMT

topic Re: Logical help in QlikView

Logical help

Re: Logical help

Re: Logical help

Re: Logical help

Re: Logical help

Re: Logical help

Re: Logical help

Irena Calovska