Is it Possible to have two different formats of values for Single Expression?

[priyav24]

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

[kaushiknsolanki · Accepted solution]

Hi,

     Try this.

     num(Sum(Amount),'#,##0.00') &'-'& num(Sum(Amount)/Sum(total Amount),'#,##0.00%')

Regards,

Kaushik Solanki