topic Re: Add a new line for a custom total in QlikView

Add a new line for a custom total

Anonymous — Tue, 29 Dec 2015 16:34:05 GMT

I need to create the following table in qlikview

I have a filter comp

How could I add a custom total above total with the same expression but with the condition of comp = O?

Anonymous — Wed, 30 Dec 2015 03:42:56 GMT

maybe,

you'll need to create

another dimension that group the two levels

like in this post.

Chanty4u — Wed, 30 Dec 2015 04:40:33 GMT

hi,

the above wil helps u

Thanks

suresh

vikasmahajan — Wed, 30 Dec 2015 05:36:54 GMT

PFA SAMPLE

Hope this helps you.

Vikas

Anonymous — Wed, 30 Dec 2015 05:40:45 GMT

like this?

tyagishaila — Wed, 30 Dec 2015 06:10:44 GMT

Try it,

Concatenate a TAB with your original Table

OriginalTAB;

Concatenate

NEWTAB:

LOAD 'Dept Total' AS DEPARTMENT,

put your fields

Resident OriginalTAB where Comp = O;

It will show a custom 'Dept Total' row in Department column.