Need help on application design

guillaume_gorli — Tue, 18 Jul 2017 09:07:57 GMT

Dear All,

Please see below the issue i am facing :

I have a sales database showing basic data :

Invoicing date
Part number
Desc
Customer
Qty
Cost
Total Cost
Selling price
Whole Goods reference
Type

This database includes whole goods part numbers as well as part numbers invoiced to the customer by repair center.

For instance customer Robsinon purchased part number 0001X000 on 01/01/2017. This part number is declared as a whole goods thanks to the field Type (which is "Whole goods"). Some days later other references have been sold to this customer to be mounted on the whole goods initially sold. The key that links all this is the field "Whole Goods reference" :

The target of the application i have to build is to sum up those warranty cost per part number but also per whole goods.

To sum warranty cost up per part number is easy :

To sum warranty cost per machine is ok as well.

The issue i am facing is that in the last table i have to show data linked to the whole goods (Description of the whole goods, invoicing date of the whole goods & customer) although the total cost column is linked to the components invoiced by repair center.

So the output i get is the following : the description and the invoicing date refers to the components sold and not the whole good.

Although what i should get is :

I attached qvw and excel test database for the ones who could help.

Thanks in advance

Guillaume

Re: Need help on application design

techvarun — Tue, 18 Jul 2017 10:30:55 GMT

Hi,

Kindly check the attached sollution feasible.

Re: Need help on application design

Anil_Babu_Samineni — Tue, 18 Jul 2017 10:35:56 GMT

This?

Sum(Aggr(Sum ({$ <[Type]={'Repair Center'}>}[Total Cost]), [Whole Goods reference]))

Re: Need help on application design

Anil_Babu_Samineni — Tue, 18 Jul 2017 10:36:39 GMT

And please check the suppress from presentation

Re: Need help on application design

guillaume_gorli — Wed, 19 Jul 2017 07:10:55 GMT

Thanks a lot !

topic Re: Need help on application design in QlikView

Need help on application design

Re: Need help on application design

Re: Need help on application design

Re: Need help on application design

Re: Need help on application design