-
Re: How to add Column Headers
Chris Wong Jul 28, 2017 4:42 AM (in response to Neha Pathak)-
Column Header.qvf 176.0 K
-
-
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
-
-
-
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
-
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')
-
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() )
-
-
-
-
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