Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have attached the app, in which I crosstab the table.
In the dimension I took the Qualifier field & Attribute field and data field as expression.
Now what I want is in that chart (demo) first 2 fields Net Sale & Net Rev are nos and Net Margin in %, so how can I change the number format for same expression.
Thanks in Advance
Upendra
Hi,
You can use a code for Sum(Data) so use some thing like below
=If(FF = 'Net Margin',Round( Num( Sum(Data)*100,'#.##' ),1 )&'%' ,Sum(Data))
See atttached sample also in Solution Sheet.
Rgds
Anand
Hi,
You can use a code for Sum(Data) so use some thing like below
=If(FF = 'Net Margin',Round( Num( Sum(Data)*100,'#.##' ),1 )&'%' ,Sum(Data))
See atttached sample also in Solution Sheet.
Rgds
Anand
only you need to change expression
=if(FF='Net Margin',NUm(sum(Data),'#.##%'),sum(Data))
see the attached file
hope this helps
here is the Qlikview built-in option to change display
right click your chart -> 'properties' -> 'number' tab -> choose the expression you want to override format.
select the format option in right hand panel.
done.
hope this help.
regards
mingming
Hi,
If you change the setting of chart to the Number for the chart then the all other value should change so if there is two type of values like
451
8%
4512
5%
you have to deside which value shown in % or number.
See the attached sample file.
Rgds
Anand