Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

chriys1337
Contributor II

Generating one additional Total Entry in Field

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.

1 Solution

Accepted Solutions

Re: Generating one additional Total Entry in Field

The second table is fairly simple

Capture.PNG

View solution in original post

5 Replies
stabben23
Honored Contributor

Re: Generating one additional Total Entry in Field

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

Is this what you are trying to get?

Capture.PNG

chriys1337
Contributor II

Re: Generating one additional Total Entry in Field

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

The second table is fairly simple

Capture.PNG

View solution in original post

chriys1337
Contributor II

Re: Generating one additional Total Entry in Field

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

Thank you so much!