Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everybody,
I have one requirement to show values in two different formats for the same expression is it possible in qlikview..
Eg:
i want to show the Expression say Sum(Amount) in Integer Format & also in percentage format in a single column
is it possible in qlikview.
Thanks in Advance,
Priya
Hi,
Try this.
num(Sum(Amount),'#,##0.00') &'-'& num(Sum(Amount)/Sum(total Amount),'#,##0.00%')
Regards,
Kaushik Solanki
Hi,
Try this.
num(Sum(Amount),'#,##0.00') &'-'& num(Sum(Amount)/Sum(total Amount),'#,##0.00%')
Regards,
Kaushik Solanki