topic Re: Conditional count of selected or not selected dimension in QlikView

Conditional count of selected or not selected dimension

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

Hello,

I'm considering the following challenge, concerning the dimension MONTH.

I need to find a expression that:

- if none month is selected, give back 0;

- if some months are selected, give back the number of the months selected;

I've tried with the following expression but doesn'tm work

=Count({<MESE={'$(=MESE)'}>}MESE)

Anyone can help me?

Thanks

Davide

sunny_talwar — Fri, 27 Jan 2017 10:38:20 GMT

Why not just this

=GetSelectedCount(MESE)

sunny_talwar — Fri, 27 Jan 2017 10:38:59 GMT

Read about GetSelectedCount() function here:

davdiste — Fri, 27 Jan 2017 10:45:41 GMT

thx Sunny, I'II read it!!!

Bye