This content has been marked as final.
Show 6 replies
-
Re: Qlikivew indent pivot without totals
Sunny Talwar May 14, 2015 4:45 PM (in response to Gabor Szikszai)You mean that you do want to see the row which shows the subtotal, but not see any values in there (just blank cells)??
-
Re: Qlikivew indent pivot without totals
Gabor Szikszai May 14, 2015 5:27 PM (in response to Sunny Talwar )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
-
Re: Qlikivew indent pivot without totals
Sunny Talwar May 15, 2015 5:43 AM (in response to Gabor Szikszai)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
-
Community_164113.qvw 148.0 K
-
Re: Qlikivew indent pivot without totals
Gabor Szikszai May 15, 2015 6:07 AM (in response to Sunny Talwar )Thank you Sunindia!
Thats perfect! That works as I expect!
-
Re: Qlikivew indent pivot without totals
Sunny Talwar May 15, 2015 6:08 AM (in response to Gabor Szikszai)Awesome I am glad we were able to resolve the issue fairly quickly.
Best,
Sunny
-
-
-
-
-
Re: Qlikivew indent pivot without totals
Dyhessyca Correa Aug 24, 2016 1:29 PM (in response to Gabor Szikszai)Please, check the correct answer.
thank you