How to do to work the MaxString function inside Count

[#1]

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.

[devarasu07]

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 &amp; MinString

Thanks,Deva

[sunny_talwar · Accepted solution]

May be this

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

[sunny_talwar]

Also, is period_rapture a text field?

[#5]

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