topic Re: Format within an expression in QlikView

Format within an expression

Mon, 01 Jul 2013 16:11:55 GMT

I am working on an expression where I am attempting to show the percent. However the requirement has changed to show the numerator, denominator and the percent all within the same column. I can get this to work but cannot figure out how to then format the percent calculation piece to only show 2 decimal places. Any ideas? I could probably split this into 2 columns but would need the expression title to be spread over both columns and I am not sure how to accomplish that. This is all being done in a pivot table. Thanks in advance!

Re: Format within an expression

shree909 — Mon, 01 Jul 2013 16:26:37 GMT

Hi,

num(ur expression,'#,##.#0%') this will give 12.23% depending on ur expression

Re: Format within an expression

Mon, 01 Jul 2013 17:39:09 GMT

Thanks, this worked our perfectly. I only modified the last 0 to a # in the formatting to get the correct rounding.