topic Absolute count of selection in QlikView

Absolute count of selection

Wed, 09 Dec 2009 15:44:09 GMT

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!

Absolute count of selection

Wed, 09 Dec 2009 15:58:06 GMT

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...

Absolute count of selection

Wed, 09 Dec 2009 17:06:01 GMT

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.

Absolute count of selection

Wed, 09 Dec 2009 22:01:37 GMT

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!

Absolute count of selection

Thu, 10 Dec 2009 18:22:00 GMT

Thanks for letting me know