topic Re: Formatting in QlikView

Formatting

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Hi Experts,

I have one expression like Sum(Cost) And i want format like #.##0. How I can assign that Format

Anonymous — Wed, 22 Jun 2016 12:07:50 GMT

just put num around

num(Sum(Cost),'#.##0')

in a Chart it is better to format it using tab number!

amit_saini — Wed, 22 Jun 2016 12:08:49 GMT

num(sum(Cost),'#.##0')

or try from below:

Thanks,
AS

sampada0810 — Wed, 22 Jun 2016 12:14:32 GMT

in title you can use num function and specify the required format

like this: num(Sum(Cost),'#.##0')

qlikview979 — Wed, 22 Jun 2016 12:21:39 GMT

Hi Prabhas,

do you want this format.

qlikview979 — Wed, 22 Jun 2016 12:23:13 GMT

Hi,

otherwise Share your Expected sample output.