Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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

See attached example


talk is cheap, supply exceeds demand

View solution in original post

5 Replies
Gysbert_Wassenaar

See attached example


talk is cheap, supply exceeds demand
Not applicable
Author

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
Author

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
Author

Dear Karthik,

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

Thanks,

Not applicable
Author

Attached..

Thanks,

Karthik