Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

davewellman
New Contributor III

SUM not doing what I expected

Hi, I am starting with QV and trying to get a simple chart built showing the 'top 10 users by XXX'. So I chose USERNAME as my dimension and SUM(variable) as the expression and then displayed the results as a bar chart. I expected this to give me one bar per USERNAME, but I'm getting multiple bars per USERNAME.  What am I doing wrong ? I'm using the Personal Edition v11. Cheers, Dave

Tags (2)
1 Solution

Accepted Solutions
davewellman
New Contributor III

SUM not doing what I expected

Just after posting this I worked out what was going wrong. The chart was only displaying one bar per username value, but there were so many values that it was only printing/displaying a few, i.e. it was not displaying every username value. I also hadn't got the 'top 10' bit working, I got confused because initiall there were exactly 10 users displayed ! Ho hum...

6 Replies
davewellman
New Contributor III

SUM not doing what I expected

Just after posting this I worked out what was going wrong. The chart was only displaying one bar per username value, but there were so many values that it was only printing/displaying a few, i.e. it was not displaying every username value. I also hadn't got the 'top 10' bit working, I got confused because initiall there were exactly 10 users displayed ! Ho hum...

mdmukramali
Valued Contributor III

SUM not doing what I expected

Dear,

David.

I think you to take something else as dimension in place of UserName, example Salary.then it will display bar for each User.

and if you want to display only top 10 users then goto-->dimension Limit tab select the check box for restrict the values and then show only largest 10 values.

hope this one will work for you.

MVP & Luminary
MVP & Luminary

SUM not doing what I expected

Hi,

Use UserName as Dimension

Expression = Sum(Field)

Chart Properties -> Dimension Limit select the check box for restrict the values and then show only largest 10 values

OR

Go to Chart Properties -> Presentation tab and select Max Number(1-100) and give 10 in text box.  Before that you need to Sort the Dimension Descending in Sort tab.

Hope this helps you.

Regards,

Jagan.

davewellman
New Contributor III

Re: SUM not doing what I expected

Hi Jagan,

Thanks for the information. As per my last post on this I've actually resolved it and have now got it working as required.

Cheers,

Dave

Ward Analytics Ltd - information in motion

Tel: +44 (0) 118 9740191

Fax: +44 (0) 118 9740192

www: <http://www.ward-analytics.com> http://www.ward-analytics.com

Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR

Registered company number: 3917021 Registered in England and Wales.

davewellman
New Contributor III

Re: SUM not doing what I expected

Hi,

Thanks for the information. As per my last post on this I've actually resolved it and have now got it working as required.

Cheers,

Dave

Ward Analytics Ltd - information in motion

Tel: +44 (0) 118 9740191

Fax: +44 (0) 118 9740192

www: <http://www.ward-analytics.com> http://www.ward-analytics.com

Registered office address: The Oriel, Sydenham Road, Guildford, Surrey, United Kingdom, GU1 3SR

Registered company number: 3917021 Registered in England and Wales.

v_iyyappan
Valued Contributor

Re: SUM not doing what I expected

Hi,

  Please give mark for proper person.It will encourage him.And also they involve lot of activities and solve our requirments.

Iyyappan