2 Replies Latest reply: May 1, 2016 3:13 AM by kushal chawda RSS

    Question regarding functionality of Custom Format Cell

    Jim Chan

      HI guys,

       

      i dont understand... ok, i have created a pivot table, and about to use custom format cell, then found out that at the "Apply Change to" can only applies to "All Dimension". 

       

      Why in some situation , at the "Apply change to" - i can choose All Dimension or Current Dimension.

       

      It is because its a Pivot Table?

       

       

      Untitled.png

       

      Rgds,

       

      Jim

        • Re: Question regarding functionality of Custom Format Cell
          Marcus Sommer

          It will be depend from this cell on where you performed the right click which options to apply the custom format is available - current dimension/expression or all. I think if you tried it a few times in different cells you will understand it better.

           

          Essential is to understand that you couldn't format a table in qlikview like you would within another tool for example excel and that you would need various methods (custom cell format, attribut expressions, design-option, visualization options) within qlikview to get near to the possibilities within excel - and would you apply everything what is possible you would probably to overstate it. Best practice goes more in the direction to highlight one or two essential points and don't format the whole table.

           

          - Marcus

          • Re: Question regarding functionality of Custom Format Cell
            kushal chawda

            If you have selected the cell from Any dimension it will ask for "All dimension" or "Current dimension" or "All dimension and expression"

            If you have selected the cell from Expression i.e Number values then it will ask for "All Expression"  or "Current Expression"or "All dimension and expression"