topic SUM not doing what I expected in QlikView

SUM not doing what I expected

Anonymous — Thu, 23 Feb 2012 19:33:52 GMT

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

SUM not doing what I expected

Anonymous — Thu, 23 Feb 2012 19:42:02 GMT

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

SUM not doing what I expected

mdmukramali — Thu, 23 Feb 2012 20:00:26 GMT

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.

SUM not doing what I expected

jagan — Fri, 24 Feb 2012 05:34:35 GMT

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

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.

Re: SUM not doing what I expected

Anonymous — Fri, 24 Feb 2012 10:45:18 GMT

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.

Re: SUM not doing what I expected

Anonymous — Fri, 24 Feb 2012 10:45:54 GMT

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.

Re: SUM not doing what I expected

v_iyyappan — Fri, 24 Feb 2012 10:57:08 GMT

Hi,

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

Iyyappan