topic Re: Count only the highest category in QlikView

Count only the highest category

berndjaegle — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys,

struggeling with the following situation:

Would like to count only the maximum category entry. I my example only the green marked fields should stay and counted = 1. All others should be removed.

Thank you for your help.

BR,

Bernd

Max Kategorie

Re: Count only the highest category

Arthur_Fong — Wed, 30 Oct 2019 01:41:04 GMT

I did this at script level:

Re: Count only the highest category

Brett_Bleess — Wed, 06 Nov 2019 15:10:43 GMT

Bernd, did Arthur's example do the trick for you? If so, do not forget to come back to the thread and use the Accept as Solution button on his post to give him credit for the help and let others know it did work. If you are still working on things, leave an update.

Regards,
Brett