Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
rajat2392
Partner
Partner

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
Partner
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
Partner

Hi,

could you have a look at the attached file?

rajat2392
Partner
Partner
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