Help with Num() (QLIKVIEW)

[Qlik_Enthu]

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'

[Anil_Babu_Samineni]

Use this?

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

[Qlik_Enthu]

No change.

[Anil_Babu_Samineni]

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

[sunny_talwar · Accepted solution]

How about this

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

[Qlik_Enthu]

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

[Qlik_Enthu]

That worked

Thanks much!!

[Anil_Babu_Samineni]

That's the sunny's power