topic Re: is getSelectedCount() work for calculated dimension? in QlikView

is getSelectedCount() work for calculated dimension?

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

Hi,

I have a calculated dimension and based on the filed selection I populate a table. But I can see now that when I select that field it appears with expression and getSelectedCount() does not working. Please help.

Thanks,

Sandip

Re: is getSelectedCount() work for calculated dimension?

tresB — Fri, 02 Feb 2018 10:52:32 GMT

Do you have a file to share that demonstrates the issue?

Re: is getSelectedCount() work for calculated dimension?

ananyaghosh — Fri, 02 Feb 2018 11:16:15 GMT

Hi,

when I am using this : =getselectedCount(DATE) and select a date , it gives me count. But when I use =getselectedCount(year(DATE)) and select a date value , it does not give me nothing.

Re: is getSelectedCount() work for calculated dimension?

shiveshsingh — Fri, 02 Feb 2018 11:57:46 GMT

Instead you can define year(DATE) in script and then use in textbox.

Re: is getSelectedCount() work for calculated dimension?

tresB — Fri, 02 Feb 2018 12:26:33 GMT

That is because that function doesn't take calculated dimension as argument but a field name (or, to be precise, - 'or expression that gives a field name').

Better create a Year field in the script and use that in the function.

Re: is getSelectedCount() work for calculated dimension?

prajwala — Fri, 02 Feb 2018 14:34:39 GMT

GetSelectedCount only works for Fields in your data model.