topic Re: Listbox - incorrect number format for frequency. in QlikView

Listbox - incorrect number format for frequency.

Mon, 26 Aug 2013 02:25:08 GMT

Hi,

I have an issue where all of my listbox frequency counts are a set number format with no comma separated thousands.

I seam to not be able to change the number format.

Re: Listbox - incorrect number format for frequency.

jagan — Mon, 26 Aug 2013 03:11:27 GMT

Hi,

I think there is no direct setting for this, we need to use List box Expression for this, please find attached file for solution.

Regards,

Jagan.

Re: Listbox - incorrect number format for frequency.

Gysbert_Wassenaar — Mon, 26 Aug 2013 09:22:37 GMT

The number settings are for the field of the listbox, not for the additional expressions you add. Try adding the num function around your expression: num( ...myexpression... , '#,###')

Re: Listbox - incorrect number format for frequency.

Fri, 13 Sep 2013 12:41:20 GMT

I have the same problem, but NUM function doesn't help.

Re: Listbox - incorrect number format for frequency.

Fri, 13 Sep 2013 12:57:38 GMT

Maybe this can help you.

Re: Listbox - incorrect number format for frequency.

Fri, 13 Sep 2013 15:57:32 GMT

Hi Leonardo,

Thanks, but I am working on a personal license, so I can only import my own stuff or otherwise I can't open anymore what I have created myself. I don't know if it is just a threat, but I don't dare to try it out.

It is a simple listbox newly created and then added a sum([# Departures Performed]) as a expression. I tried the Number tab of the Properties dialog, but nothing helped. I then added in the expression the NUM function, but no succes either.

Is it possible to send some screenshots? By the way I am working with version 11.

Thanks,

Patrick

Re: Re: Listbox - incorrect number format for frequency.

Fri, 13 Sep 2013 16:04:41 GMT

Num( sum([# Departures Performed]),'#,###')

The result is

Re: Re: Listbox - incorrect number format for frequency.

Fri, 13 Sep 2013 19:26:44 GMT

Thanks Leonardo,

I checked my expression again and somehow I used NUM# instead of NUM. I read the help about the NUM# function and now understand the output that I got. I changed it to NUM and now it is okay.