Absolute count of selection

[#1]

I am in the beginning of doing QlikView, and I would need assistance to create a simple formula in a graph.

I have a selection field Name, and another selection field Project which is data from the same Excel sheet.

I would like to create a counter for selection field Name, so that if I make 3 selections in field Name, it shows 3, and if I make a restriction with selection field Project, this counter would still show 3 (even if only 1 Name should be found in that Project list).

I have tried count(Name) and GetSelectedCount(Name), but they always return 1, which basically is correct, but not the figure I need... [:)]

Any help would be greatly appreciated!

[#2]

Hi

Not sure how much this will help. Try

count({$1} Name)

This will always show the count for the previous selection. So if you select 3 names and then make a selection on the products it will display 3. Any more selections will invalidate it though. Not sure how you wanted to approach it...

[#3]

Thanks, this will give the right answer! But the problem is that I am not able to tell beforehand, in which order the graph selections are being made. It could be that the user selects one of the Projects first and then makes the Name selections, then clears the project selection etc.

I would just need a 'really dumb' formula to tell how many selections have been made in a specific field.

[#4 · Accepted solution]

Solved, by using the next formula:

= getselectedcount(Name, 1)

This returns me the selected ones (and including the excluded with the clause TRUE or 1). Simple but tricky!

[#5]

Thanks for letting me know