topic Re: How to do to work the MaxString function inside Count in QlikView

How to do to work the MaxString function inside Count

Wed, 25 Nov 2020 16:16:04 GMT

Hi, I'm trying to make this function work, "COUNT (DISTINCT {$ <name, group = {'SERVERS', 'SERVERS - COMMISSIONERS', 'SERVERS - EXTRA FRAME'}, $ (MaxString (period_rapture))} registration)"

Where I can not make MaxString work in the function, how can I help myself, I'm new to the qlik tool.

Re: How to do to work the MaxString function inside Count

devarasu07 — Mon, 21 Aug 2017 08:16:34 GMT

Hi,

Try like this. put it inside your set analysis expression (remember to update your dimension field name in below expression)

COUNT (DISTINCT {$ <name, group = {'SERVERS', 'SERVERS - COMMISSIONERS', 'SERVERS - EXTRA FRAME'}, Dimension={$(=MaxString(period_rapture))} registration)

also check this,

How to use - MaxString & MinString

Thanks,Deva

Re: How to do to work the MaxString function inside Count

sunny_talwar — Mon, 21 Aug 2017 12:08:22 GMT

May be this

COUNT (DISTINCT {$ <name, group = {'SERVERS', 'SERVERS - COMMISSIONERS', 'SERVERS - EXTRA FRAME'}, period_rapture = {"$(=MaxString(period_rapture))"}>} registration)

Re: How to do to work the MaxString function inside Count

sunny_talwar — Mon, 21 Aug 2017 12:08:58 GMT

Also, is period_rapture a text field?

Re: How to do to work the MaxString function inside Count

Mon, 21 Aug 2017 13:22:38 GMT

Good morning, thank you very much. It worked, thank you for the strength.