Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_Enthu
Creator II
Creator II

Help with Num() (QLIKVIEW)

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'

1 Solution

Accepted Solutions
sunny_talwar

How about this

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

View solution in original post

7 Replies
Anil_Babu_Samineni

Use this?

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Qlik_Enthu
Creator II
Creator II
Author

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
sunny_talwar

How about this

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

Qlik_Enthu
Creator II
Creator II
Author

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
Creator II
Creator II
Author

That worked

Thanks much!!

Anil_Babu_Samineni

That's the sunny's power

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful