topic Re: Sub Total in QlikView

Sub Total

subbareddykm — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

By using my data is ,Can we achieve my expected output.

Note :

1.In Sub Total I do not want Bifurcation on Brand , can we able to show same like i have mentioned in output file .

2.Can we able to get in Total as my brand Plant Name ?

3.If its not possible , suggest me alternate methods.

Thankx in Adv

Re: Sub Total

Anil_Babu_Samineni — Sun, 02 Oct 2016 06:48:31 GMT

If you are expecting text to vertical, It's not possible. Some work around it will come. But, you need to change script

Re: Vertical Data Text in Pivot Table

No, all subtotal labels for one dimension will have the same value. =Year & 'Total' will only work when only one year is selected/possible. See this post for an alternative:

Try This Expression for Model from Presentation Tab which is Under Label for Totals

=If(Dimensionality() =2, '' & Plant & ':' & Sum([Val 1])+Sum([Val 2])+Sum([Val 3])+Sum([Val 4]))

This for Each Expression like this

=If(Dimensionality() =2, '' & Company & ':' & Plant & ':' & Sum([Val 1]), sum([Val 1]))

=If(Dimensionality() =2, '' & Company & ':' & Plant & ':' & Sum([Val 2]), sum([Val 2]))

=If(Dimensionality() =2, '' & Company & ':' & Plant & ':' & Sum([Val 3]), sum([Val 3]))

=If(Dimensionality() =2, '' & Company & ':' & Plant & ':' & Sum([Val 4]), sum([Val 4]))

And then check if that suitable. And Company is unnecessary here.

Hope This helps

Re: Sub Total

Kushal_Chawda — Sun, 02 Oct 2016 08:33:08 GMT

see the attached

edit: changed the expression to match grand total

Re: Sub Total

subbareddykm — Mon, 03 Oct 2016 02:42:22 GMT

Thankx for ur responce.

there two things.

1. I Dont Want to use Brand in dimentions.

2.Ur output is almost same but I dint want to bifurcate the Brand for Comopany A and C rest i want same like you did.

Thankx in adv

Re: Sub Total

subbareddykm — Mon, 03 Oct 2016 02:47:57 GMT

Is it possible to achieve ?

Re: Sub Total

subbareddykm — Mon, 03 Oct 2016 02:53:29 GMT

This is the output format .

Re: Sub Total

nagarjuna_kotha — Mon, 03 Oct 2016 04:02:27 GMT

I guess, technically it is not possible.

-Nagarjun

Re: Sub Total

Anil_Babu_Samineni — Mon, 03 Oct 2016 05:31:58 GMT

1) Simple remove the Dim

2) Like this

Re: Sub Total

subbareddykm — Mon, 03 Oct 2016 05:49:10 GMT

I don't Want to bifurcate for for Company A and D only rest i want bifurcation on Brand.

is it possible?

Re: Sub Total

Anil_Babu_Samineni — Mon, 03 Oct 2016 05:50:56 GMT

What do you mean bifurcate? Would you describe more. In you WORD format showing A & D. What you don't want to show?

Re: Sub Total

subbareddykm — Mon, 03 Oct 2016 05:56:32 GMT

Can u see output file which i provided above.

For Company A and D, I don't want total for Brand A and Brand B. Which i shown in Output format.