Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Derived Data based on condition

Hi,

Based on the below tables, I need to derive the third table called Required Data.
Based on Priority & Model Code from Priority table, need to compare the Data table contents & derive the resultant Required Data table.

Please refer the attached excel file for the reference.

Priority:

PriorityModel CodeModel Name
4RZF50RAstar
3LF50RBstar
2TGN40RCstar
1KUN40RDstar
5OTHERSOTHERS

Data:

Applicable Model 1Applicable Model 2Applicable Model 3Applicable Model 4Applicable Model 5Applicable Model 6
ACV30RGRJ120KUN40RKUN51RTGN40R
ACV30RGRJ120LF50RNDE140ZRE142
ACV30RGRJ120NDE140NGK15RNUK10R
ACV30RGRJ120NDE140NUK10RNUK15R
ACV30RGRJ120NDE140ZRE142ZVW30R
KUN40RGRJ120NDE140ZRE142ZZE142
ACV30RGRJ120NUK10RNUK15RZVW30R
ACV30RGRJ120TGN40R
ACV30RGRJ120TGN40RZRE142ZVW30R
ACV30RGRJ120ZVW30R
ACV30RKUN40R
ACV30RKUN40R
KUN40RTGN40R

Required Data:

Model NameApplicable Model 1Applicable Model 2Applicable Model 3Applicable Model 4Applicable Model 5Applicable Model 6
DstarACV30RGRJ120KUN40RKUN51RTGN40R
BstarACV30RGRJ120LF50RNDE140ZRE142
OTHERSACV30RGRJ120NDE140NGK15RNUK10R
OTHERSACV30RGRJ120NDE140NUK10RNUK15R
OTHERSACV30RGRJ120NDE140ZRE142ZVW30R
DstarKUN40RGRJ120NDE140ZRE142ZZE142
OTHERSACV30RGRJ120NUK10RNUK15RZVW30R
CstarACV30RGRJ120TGN40R
CstarACV30RGRJ120TGN40RZRE142ZVW30R
OTHERSACV30RGRJ120ZVW30R
DstarACV30RKUN40R
DstarACV30RKUN40R
DstarKUN40RTGN40R
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Derived Data based on condition

See attached example


talk is cheap, supply exceeds demand
5 Replies
Gysbert_Wassenaar
Not applicable

Re: Derived Data based on condition

See attached example


talk is cheap, supply exceeds demand
Not applicable

Re: Derived Data based on condition

Dear Gysbert,
Thanks for your quick response.
Solution is working fine but we need to consider the Priority number also from the Priority table while deriving the resultant data.

Based on the model code & Priority i.e. higher to lower, 1-5 we need to derive the data.


Thanks,

Raja

Not applicable

Re: Derived Data based on condition

Hi Raja,

Find attached file..

I have used same file which Gysbert developed..

Added Priority table separately on top of data table and did "Load  Order - Original" on Sort(Table Properties)

Not applicable

Re: Derived Data based on condition

Dear Karthik,

Can u share the file which u have worked on..

Thanks,

Not applicable

Re: Derived Data based on condition

Attached..

Thanks,

Karthik