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: 
rajat2392
Partner - Creator III
Partner - Creator III

Get the aggregated data in expression

Hi everyone

I have two tables, one with 4 fields, those are a Unique Chasis no., Model, Year, Feature_opted.

Second table has 3 fields, those are Model, Feature, and Category. Category states as optional or standard. Standard means the vehicle will must have this feature and optional a customer may opt.

I want to show two tables, one which shows the opted features, and other that shows only the optional features for that model. See the picture below.

Data is attached. Please reply soon as possible.

Thanks

Rajat

1 Solution

Accepted Solutions
rajat2392
Partner - Creator III
Partner - Creator III
Author

Hi Michele

Thanks for the answer, but it is not exactly what I required.

What I require is the second table should show all the features that are optional, either opted or not by the customer. But all the optional feature should come.

So with reference to your answer, I have created this which gives me what I needed. Thanks for the helpful answer.

Rajat

View solution in original post

2 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

Hi,

could you have a look at the attached file?

rajat2392
Partner - Creator III
Partner - Creator III
Author

Hi Michele

Thanks for the answer, but it is not exactly what I required.

What I require is the second table should show all the features that are optional, either opted or not by the customer. But all the optional feature should come.

So with reference to your answer, I have created this which gives me what I needed. Thanks for the helpful answer.

Rajat