topic Re: Total whitout one column in QlikView

Total whitout one column

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

Hello Qliks,

Currently, my applications show Total of all columns, like below:

Are exist way to exclude one column from that total? Of course, that column should be still present in the table. Column, which I want to exclude is:

Dim Year-Month = 2017-May && Dim Plan Code = FCT

Regards

Jacek.

Re: Total whitout one column

prat1507 — Thu, 22 Jun 2017 13:54:42 GMT

See Attached example. Refer to Conditional show/hide sub totals in Pivot table

Regards

Pratyush

Re: Total whitout one column

Anonymous — Thu, 22 Jun 2017 14:02:24 GMT

Thank you Pratyush, but is not what I look. That solution just hide/show total and I want to see all time total, but minus one column.

Regards

Jacek.

Re: Total whitout one column

sunny_talwar — Thu, 22 Jun 2017 14:04:27 GMT

Would you be able to share a sample where you are trying to do this? Also, you want the total to not include Fcst where Actual and Fcst are both available?

Re: Total whitout one column

Anonymous — Thu, 22 Jun 2017 14:27:29 GMT

Hello Sunny,

Yes, I want that total, which you described. Unfortunately, I can't attach that application, because contain many important data for firm. I tried to eeduce data by Preparing examples for Upload - Reduction and Data Scrambling but without success.

Regards

Jacek.

Re: Total whitout one column

sunny_talwar — Thu, 22 Jun 2017 14:28:28 GMT

What was the issue you ran into while reducing and scrambling your data?

Re: Total whitout one column

Anonymous — Fri, 23 Jun 2017 09:57:54 GMT

Hello Sunny, I had yesterday problem with connection. I prepare special app just with the problem.

Re: Total whitout one column

Frank_Hartmann — Fri, 23 Jun 2017 10:03:34 GMT

Please reupload!

Access denied to this QV document!

Re: Total whitout one column

Anonymous — Fri, 23 Jun 2017 10:12:17 GMT

Yes, I forgot about section access. New upload.

Re: Total whitout one column

sunny_talwar — Fri, 23 Jun 2017 11:15:45 GMT

May be this

If(Dimensionality() = 0,

Sum({1}Aggr(If(Above($(vRevenue)) > 0 and Above(Only({1<[Plan Code] = {'ACT', 'FCT'}>}[Plan Code])) = 'ACT', 0, $(vRevenue)), [Year-Month], [Plan Code])),

$(vRevenue))

Re: Total whitout one column

sunny_talwar — Fri, 23 Jun 2017 11:28:14 GMT

My bad, you need this

If(SecondaryDimensionality() = 0,

Sum({1}Aggr(If(Above($(vRevenue)) > 0 and Above(Only({1<[Plan Code] = {'ACT', 'FCT'}>}[Plan Code])) = 'ACT', 0, $(vRevenue)), [Year-Month], [Plan Code])),

$(vRevenue))

Re: Total whitout one column

Anonymous — Fri, 23 Jun 2017 11:45:49 GMT

Thank you, Sunny. One more time you proofed that impossible is possible.I wish you a good day.

Regards

Jacek.