Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
Partner
Partner

Re: Get the aggregated data in expression

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

Re: Get the aggregated data in expression

Hi,

could you have a look at the attached file?

Partner
Partner

Re: Get the aggregated data in expression

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