topic Generating one additional Total Entry in Field in QlikView

Generating one additional Total Entry in Field

chriys1337 — Wed, 07 Mar 2018 09:08:13 GMT

Hi,

I am having several Customer which are producing Revenue and I would like to see the split of the different revenue sorts for each customer in a first table.

But I would like to have a split between these revenues also for a "Total Customer" line, in a second table.

I have made a sample and also added the wished outcome as Excel Screenshot. Can somebody ´please give me a tip how to achieve this in QlikView? Do I have to load my complete twice, but the second time with the Customer Name "Total"?

Thx for your help.

Re: Generating one additional Total Entry in Field

stabben23 — Wed, 07 Mar 2018 10:11:19 GMT

Hi Christian,

look in the Attached if this helps.

One table is without customer_name as Dimension and one is made in script

Re: Generating one additional Total Entry in Field

sunny_talwar — Wed, 07 Mar 2018 10:27:01 GMT

Is this what you are trying to get?

Re: Generating one additional Total Entry in Field

chriys1337 — Wed, 07 Mar 2018 11:07:54 GMT

Hi both,

thanks a lot, this is getting in the right direction.

@Sunny, I would like to have a second table with just the Dimension Entry"All Customers", is this also possible with your approach?

Re: Generating one additional Total Entry in Field

sunny_talwar — Wed, 07 Mar 2018 11:10:27 GMT

The second table is fairly simple

Re: Generating one additional Total Entry in Field

chriys1337 — Wed, 07 Mar 2018 11:12:41 GMT

That's too easy, I can't imagine this is working... my fault.

Thank you so much!