Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
How about this
=Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)), '#,##0', '.', ',')
Use this?
=Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)),'#,##0')
No change.
Looks like working with me, Not sure what's going with u? Will you provide sample application? And i've used #,##0
How about this
=Num(Count(if(match(DEV_CODE,'NR'),INT_ORD_NO)), '#,##0', '.', ',')
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
That worked
Thanks much!!
That's the sunny's power