6 Replies Latest reply: Aug 24, 2016 1:29 PM by Dyhessyca Correa

Qlikivew indent pivot without totals

Gabor Szikszai May 14, 2015 4:17 PM

Hi All,

Is it possible to use indent pivot table without subtotals?

Thanks

Gabor

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)??
Like Show 0 Likes (0)

Actions
- 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
  
  Like Show 0 Likes (0)
  
  Actions
  - 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
    
    Like Show 0 Likes (0)
    
    Actions
    - 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!
      
      Like Show 0 Likes (0)
      
      Actions
      - 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
        
        Like Show 0 Likes (0)
        
        Actions
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
Like Show 0 Likes (0)

Actions

Go to original post