topic Re: Subtotals in Straight Table in QlikView

Subtotals in Straight Table

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

Hello there,

i know that its possibly to get sub totals in a straight table by using the Dimension Limit Tab in Proberties.

For examble, i got two dimensions "Year/cw" and "Date", when i check the box Show totals on the second Dimension "Date", i ll get

several empty rows for "Year/cw" without data... i want to hide these rows...

Nachricht geändert durch Bernd Mensing

Re: Subtotals in Straight Table

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:17:35 GMT

Better if you provide sample mock up

Re: Subtotals in Straight Table

bmensing — Tue, 18 Jul 2017 13:25:34 GMT

its like

YEAR/CW DATE AMOUNT

2017/1 SubTotal 0,00

2017/2 SubTotal 0,00

2017/3 SubTotal 0,00

2017/4 SubTotal 140,12

i want to hide the first three rows...

Re: Subtotals in Straight Table

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:28:49 GMT

Do you un check the Suppress null value from presentation Tab?

Re: Subtotals in Straight Table

Tue, 18 Jul 2017 13:30:10 GMT

Please check the Presentation tab for the chart and Check the option "Supress Zero-Values"

Re: Subtotals in Straight Table

bmensing — Tue, 18 Jul 2017 13:39:28 GMT

i've done that so far but the rows are still there...

Re: Subtotals in Straight Table

Tue, 18 Jul 2017 13:40:49 GMT

Is the Amount column defined as a dimension or as an expression? The suppress zero values option will only impact expressions. Make sure the logic for the Amount is defined on the Expressions tab, and not on the Dimensions tab of the chart properties.

Re: Subtotals in Straight Table

bmensing — Tue, 18 Jul 2017 13:58:38 GMT

i ve created a sample, hope that will help!

Re: Subtotals in Straight Table

Tue, 18 Jul 2017 14:08:46 GMT

I agree, that behaviour looks a bit quirky.

You could try replacing the Dimension definition for Date using this formula:

=If(Aggr(Sum(Amount), Date)<>0,Date)

Switching to a fully expanded pivot table also seems to work (but you lose the sorting of the straight table then).

Re: Subtotals in Straight Table

bmensing — Tue, 18 Jul 2017 14:26:20 GMT

Thank you so much, this is the perfect solution... needless to say that the Pivot is much slower due to the Performance...