Total Count in Statistics Box

[#1]

Greetings

I am trying to use the statistics box encountered the following.

I have large data with unique USER_ID and  POINTS by Users.

If I use the statistics box

1. The Total Count shown is higher than actual User_ID's count. Any idea why?

2. How do I get DISTINCT  Total Count in Statistics Box? There is already a posting related tho DISTINCT in Total Count but the solution provided is not user friendly. Any other way? Distinct Total Count in Statistics Box | Qlik Community

Thank you

[sundarakumar]

Hi Ram,

I have worked on another workaround, PFA.

I have loaded the particular field as an island table distinct so thet it can be shown distinct.

In Qlikview we cannot make it to show distinct in static box, yet y can show all the details in a text box as u wish

like

='Total Count = '& count( distinct userid)&chr(10)&'sum  ='&sum(userid)

and so on in a text box

Hope this helps.

-sundar