topic Re: Static value in getselectedcount()? in QlikView

Static value in getselectedcount()?

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

Hi ,

This might be little silly , but am not able to figure out the appropriate solution for this.

is there way we can have a constant value in getselectedcount() .

my requirement is when my document is launched some set of ID get selected automatically.

I want that set of records to be stored in a variable or even a expression will do .

As per the current logic when we do more selections on that ID the Count changes.

=GetSelectedCount(ID)

Re: Static value in getselectedcount()?

dplr-rn — Thu, 16 May 2019 14:11:55 GMT

Not clear at all.
Understood that you need an ID selected automatically on open. (you can use triggers for that)
Did not understand why you need getselectedcount to remain constant.
Do you mean that only 1 ID should be selected always?

Re: Static value in getselectedcount()?

aniketsr — Thu, 16 May 2019 14:28:23 GMT

i want to get the count of ID's when the dashboard is launched and that count has to be stored which can be used across the dashboard later . Triggers are set already.

Re: Static value in getselectedcount()?

dplr-rn — Thu, 16 May 2019 14:35:12 GMT

Ok. Not sure how you can achieve it with getselectedcount.
But maybe you can try with count function and set analysis. use same logic as trigger in count and ignore selections. something like count({1<TRIGGERCONDITION>} ID)