7 Replies Latest reply: Aug 1, 2017 3:05 AM by Neha Pathak

How to add Column Headers

Neha Pathak Jul 28, 2017 2:03 AM

I want structure like below:

Header 1 Header 2

Expression1 Expression2 Expression 3 Expression 4 Expression 5

Can this be achieved with pivot table? If yes kindly give detailed procedure with what expressions need to be used

Re: How to add Column Headers

Chris Wong Jul 28, 2017 4:42 AM (in response to Neha Pathak)
Header:
Load * inline
[
H1, H2
'Header 1','1'
'Header 1','2'
'Header 2','3'
'Header 2','4'
'Header 2','5'
]
;

Column Header.qvf 176.0 K
Like Show 0 Likes (0)

Actions
- Re: How to add Column Headers
  
  Neha Pathak Jul 31, 2017 1:18 AM (in response to Chris Wong)
  
  My query is still not solved as the header name is repeating for every set of measures. I want to apply headers on measures selectively.
  
  Like Show 1 Like (1)
  
  Actions
  - Re: How to add Column Headers
    
    Chris Wong Jul 31, 2017 2:38 AM (in response to Neha Pathak)
    
    Data load editor
    Header:
    Load * inline
    [
    H1, H2
    'Header 1','Expression 1'
    'Header 1','Expression 2'
    'Header 2','Expression 3'
    'Header 2','Expression 4'
    'Header 2','Expression 5'
    ]
    ;
    
    Detail:
    Load * inline
    [
    Number,Expression 1,Expression 2,Expression 3,Expression 4,Expression 5
    '1','1','2','3','4','5'
    '2','11','12','13','14','15'
    '3','21','22','23','24','25'
    ]
    ;
    
    Measure:
    If(H2 = 'Expression 1', ([Expression 1]),
    If(H2 = 'Expression 2', ([Expression 2]),
    If(H2 = 'Expression 3', ([Expression 3]),
    If(H2 = 'Expression 4', ([Expression 4]),
    If(H2 = 'Expression 5', ([Expression 5])
    )))))
    
    Column Header.qvf 176.0 K
    
    Like Show 0 Likes (0)
    
    Actions
- Re: How to add Column Headers
  
  Neha Pathak Jul 31, 2017 8:21 AM (in response to Chris Wong)
  
  Hi thanks Chris I am able to segregate the measures but am facing some limitations. Can you tell how to limit the value of a number while applying the condition.
  
  for example,
  My expression is sum(revenue), I want the number to be limited to 2 decimal value whereas in other expression I want a whole number
  
  Like Show 0 Likes (0)
  
  Actions
  - Re: How to add Column Headers
    
    Chris Wong Jul 31, 2017 8:19 PM (in response to Neha Pathak)
    
    Refer Conventions for number and time formats ‒ Qlik Sense
    
    Integer
    =Num('123.45','###0') = 123
    
    2 decimals
    =Num('123.45','0.00') = 123.45
    = Num(Sum([revenue]),'0.00')
    
    Like Show 0 Likes (0)
    
    Actions
    - Re: How to add Column Headers
      
      Neha Pathak Aug 1, 2017 3:05 AM (in response to Chris Wong)
      
      Thanks Chris , It worked.
      
      I have one more question kindly help me out
      
      I want to add Text Color Expression
      
      After first and second selection there should be no change in text color
      and after third selection from filter pane, colors should change as per the comparison between first and second selection.
      
      I am using this expression:-
      
      if (count({$}empid) > count({$1}empid) , Red() , Green() )
      
      Like Show 0 Likes (0)
      
      Actions
Re: How to add Column Headers

Arvind Patil Jul 31, 2017 1:29 AM (in response to Neha Pathak)

HI Neha,

Please create inline table for your headers and use this into your pivot table.
Like Below:

INLINEDATA:
Load * inline [
Headers
Header1
Header2
Header3
Header4
];

Thanks,
Arvind Patil
Like Show 0 Likes (0)

Actions

Go to original post