topic Re: Why does the 'count' disappears when I select a ListBox item? in QlikView

Why does the 'count' disappears when I select a ListBox item?

Fri, 21 Nov 2014 10:48:53 GMT

Hello Everyone!

I'm pretty new to the awesomeness of qlikview potentiality.

And I have a issue:

A have an super simple application that, when I select any list box item, the 'count' of other ones disappears, as example below:

Ex: (no one selected)

Argentina____50000

Brazil_______13000

USA___________8500

UK____________1250

...and then I select any, like USA, and this happens:

Argentina________0

Brazil___________0

USA___________8500 ***(Highlighted)

UK_______________0

Did you noticed? The other values turned to '0'. Why?

I'd like to select any item as I need and still be able to see the other numbers.

Someone knows if this is possible?

(Sorry for the newbieness)

Re: Why does the 'count' disappears when I select a ListBox item?

ali_hijazi — Fri, 21 Nov 2014 10:52:41 GMT

ignore the selection of the country if your expression is count(Items) then it will be like:

Count({<Country=>}Items)

Re: Why does the 'count' disappears when I select a ListBox item?

Peter_Cammaert — Fri, 21 Nov 2014 11:09:22 GMT

Ali's solution is the right one. But why does it happen?

The expression in the second column of the list box depends on associations between a country and whatever you are counting. As soon as you select a single country, only those records linked to that particular country will be active in your data model, and the others will loose their association, leading to zero values.

Ali's solution forces QlikView to step out of the normal associative logic, and act like nothing has been selected.

Re: Why does the 'count' disappears when I select a ListBox item?

Fri, 21 Nov 2014 11:19:02 GMT

(*-*) (my eyes are shining!)

THANK YOU A LOT Ali Hijazi!

Re: Why does the 'count' disappears when I select a ListBox item?

Fri, 21 Nov 2014 11:21:46 GMT

Thak you so much Peter Cammaert !!!

I hope to learn QlikView more and more! 😃