topic Re: Selected Months or Days in QlikView

Selected Months or Days

Tue, 20 Dec 2016 10:20:58 GMT

Good day.

i am hoping that someone could point me in the right direction.

i have list boxes with Years, Months and Days. i need to determine if there are any months or days selected and how many are selected.

i have the following expression

Count(DISTINCT([Month]))

Count(DISTINCT([Day]))

if there are any months or days selected it gives me the correct count, but if none are selected it gives me the full count (eg. 12 months if none are selected)

how can i determine if any months or days are selected?

any help would be appreciated.

Re: Selected Months or Days

kaushiknsolanki — Tue, 20 Dec 2016 10:25:20 GMT

Hi,

Try this functions.

Getselectedcount(FieldName)

GetPossibleCount(FieldName)

Regards,

Kaushik Solanki

Re: Selected Months or Days

Tue, 20 Dec 2016 10:27:52 GMT

Thank you so much Kaushik.

That is perfect.

Thank you so much for taking the time to help me.

Re: Selected Months or Days

kaushiknsolanki — Tue, 20 Dec 2016 10:31:38 GMT

Its a pleasure...

Regards,

Kaushik Solanki