topic Re: Count If Number format in Text Ojbect in QlikView

Count If Number format in Text Ojbect

nigelapt — Mon, 11 Mar 2019 10:26:25 GMT

Hi folks

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.

Thanks

Nigel

Vegar — Mon, 11 Mar 2019 11:32:44 GMT

Try using NUM() to define your presentation

='Critical '&NUM( Count(IF([DWH Severity]='Critical',0)), '#,###.','.',',')

nigelapt — Mon, 11 Mar 2019 13:34:57 GMT

Hi Vegar,

Thank you very much for taking time to look at my problem, and replying.

It's fixed!

I had been trying to get this sorted for days.

Thanks again.

Nigel

Vegar — Mon, 11 Mar 2019 13:37:01 GMT

I'm glad to be of help.

/Vegar