topic Re: A simple sum not working in QlikView

A simple sum not working

Wed, 02 Oct 2013 13:42:30 GMT

Hi there,

I have a simple sum that for some strange reason I cannot get it to work 100%.

The data is as follows;

Date |Servername|HardwareStatus|Processor|CoreProcessor

Aug 2013|Server 1 |New |1 |2

Aug 2013|Server 2 |New |1 |2

Aug 2013|Server 3 |New |2 |4

Aug 2013|Server 4 |New |2 |4

Aug 2013|Server 5 |New |1 |1

Aug 2013|Server 6 |New |1 |1

Aug 2013|Server 7 |Old |1 |2

Aug 2013|Server 8 |Old |1 |2

Aug 2013|Server 9 |Old |1 |2

Aug 2013|Server 10 |New |1 |6

- I need to firstly Count the #number of server where the CoreProcessor is <= 4 and hardware status is "New". Then need to SUM the Processor for this.

Basically looking for a chart that shows - New | Count 6| Sum 8

- I need a view that includes the servername and one that excludes the servername

Re: A simple sum not working

swuehl — Wed, 02 Oct 2013 13:47:30 GMT

=count(if(CoreProcessor <=4, Servername))

=sum(if(CoreProcessor <=4, Processor))

=count( {< CoreProcessor = {"<=4"} >} Servername)

=sum( {< CoreProcessor = {"<=4"} >} Processor)

used in a chart with dimension Servername or without any dimensions.

Re: A simple sum not working

Anonymous — Wed, 02 Oct 2013 13:54:26 GMT

Try this. See attached.

Re: A simple sum not working

kouroshkarimi — Wed, 02 Oct 2013 13:55:11 GMT

I used count({<CoreProcessor={'<=4'},HardwareStatus={'New'}>}Servername)

and sum({<CoreProcessor={'<=4'},HardwareStatus={'New'}>}Processor)

How do we upload example files now?

Edit: Found it. see attached.

Re: A simple sum not working

Wed, 02 Oct 2013 14:20:09 GMT

I think im doing something really silly ... see attachment

What I would like to see is firstly a count of all where the CorePr is <= 4 and then to SUM the ProcessCards.

It seems to have an issue because the ProcessCards has the same value.

Re: A simple sum not working

Wed, 02 Oct 2013 14:36:33 GMT

Re: A simple sum not working

kouroshkarimi — Wed, 02 Oct 2013 14:48:35 GMT

Use If(CoreProcessor<=4,Sum(ProcesserCards),0)

But you should look into Set Analysis rather than using If statements in your expressions like that. See the examples above.

Re: A simple sum not working

Wed, 02 Oct 2013 15:50:24 GMT

I will look at Set Analysis ...

basically for the above sample data, the results should be Count 6 and Sum 8 ...

just not working for me

Re: A simple sum not working

MK_QSL — Wed, 02 Oct 2013 16:09:09 GMT

Please check enclosed document...