Qlikivew indent pivot without totals

[#1]

Hi All,

Is it possible to use indent pivot table without subtotals?

Thanks

Gabor

[sunny_talwar]

You mean that you do want to see the row which shows the subtotal, but not see any values in there (just blank cells)??

[#3]

I mean I have two dimensions next to each other. I have to use indent mode, but I don't want to see totals on Dimension1 level only just blank cells.

Do you have any idea?

Thanks you

Gabor

[sunny_talwar]

Is this your goal?

If yes then you can use this expression:

=If(Dimensionality() = 1, ' ', If(Dimensionality() = 2, yourExpression))

Attaching a sample for your reference.

HTH

Best,

Sunny

[#5]

Thank you Sunindia!

Thats perfect! That works as I expect!

[sunny_talwar]

Awesome I am glad we were able to resolve the issue fairly quickly.

Best,

Sunny

[Anonymous]

Please, check the correct answer.

thank you