topic Re: Get the aggregated data in expression in QlikView

Get the aggregated data in expression

rajat2392 — Tue, 06 May 2014 11:49:26 GMT

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

Re: Get the aggregated data in expression

bbi_mba_76 — Tue, 06 May 2014 13:52:19 GMT

Hi,

could you have a look at the attached file?

Re: Get the aggregated data in expression

rajat2392 — Wed, 07 May 2014 04:25:56 GMT

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