topic Help with Num() (QLIKVIEW) in Archived Groups

Help with Num() (QLIKVIEW)

Qlik_Enthu — Tue, 22 Jul 2025 17:59:49 GMT

Dear All,

This is my expression: =Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)))

Result: 14366

Requirement is to display the numbers with comma in the Textbox (KPI)

Issue: if I use the expression =Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)),'##,##0')

I am getting the below result:

Could someone help me if I am missing something>

P.S: I have also tried with NUM#() with 'ThousandSep'

Re: Help with Num() (QLIKVIEW)

Anil_Babu_Samineni — Fri, 19 Jan 2018 13:52:14 GMT

Use this?

=Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)),'#,##0')

Re: Help with Num() (QLIKVIEW)

Qlik_Enthu — Fri, 19 Jan 2018 13:55:34 GMT

No change.

Re: Help with Num() (QLIKVIEW)

Anil_Babu_Samineni — Fri, 19 Jan 2018 13:58:21 GMT

Looks like working with me, Not sure what's going with u? Will you provide sample application? And i've used #,##0

Re: Help with Num() (QLIKVIEW)

sunny_talwar — Fri, 19 Jan 2018 13:59:10 GMT

How about this

=Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)), '#,##0', '.', ',')

Re: Help with Num() (QLIKVIEW)

Qlik_Enthu — Fri, 19 Jan 2018 14:06:29 GMT

Intiially it was working but after using Qlik Deployment Framework this is not working. Not sure if that is the cause of the issue either. I do not have sample application to share

Re: Help with Num() (QLIKVIEW)

Qlik_Enthu — Fri, 19 Jan 2018 14:09:20 GMT

That worked

Thanks much!!

Re: Help with Num() (QLIKVIEW)

Anil_Babu_Samineni — Fri, 19 Jan 2018 14:11:03 GMT

That's the sunny's power