Total Count in Statistics Box

Wed, 09 Apr 2014 00:19:09 GMT

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

Re: Total Count in Statistics Box

sundarakumar — Wed, 09 Apr 2014 04:51:15 GMT

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

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

and so on in a text box

Hope this helps.

-sundar

topic Re: Total Count in Statistics Box in QlikView

Total Count in Statistics Box

Re: Total Count in Statistics Box