Discussion Board for collaboration related to QlikView App Development.
I have this expression in a Text Object to count the values in the DWH Severity field where the severity equals Critical
='Critical '&Count(IF([DWH Severity]='Critical',0))
Value returned is 177342 but I need it to be 177,342.
Any advice would be greatly appreciated.
Try using NUM() to define your presentation
='Critical '&NUM( Count(IF([DWH Severity]='Critical',0)), '#,###.','.',',')
View solution in original post
Thank you very much for taking time to look at my problem, and replying.
I had been trying to get this sorted for days.
I'm glad to be of help.