topic Re: Help in QlikView

Help

NavinReddy — Mon, 26 Aug 2013 12:30:43 GMT

I have excel which has 1-100 values

how can i calculate sum(1-50) records

help me some one

Thanks in advance

rohith

Re: Help

tresB — Mon, 26 Aug 2013 12:34:55 GMT

What are the fields? Do you want to load all rows into qv? Does the summation depend on the row order?

Re: Help

Siva_Sankar — Mon, 26 Aug 2013 12:39:00 GMT

can you please upload the file?

Re: Help

NavinReddy — Mon, 26 Aug 2013 12:40:41 GMT

Hi,

Sample excel take 10 records i need tobe sum 1-5 records

Thanks in advance

rohith

Re: Help

nilesh_gangurde — Mon, 26 Aug 2013 12:40:46 GMT

Hii Niranjan,

Load the table with the where condition. also add the One more field to identify the data.

then concat the rest of the data.

please see the code below,

Load *

' 1 -50' as Field

From table_Name where Condition(For 1-50 rows);

Concatenate

Load *

' 51 - 100' as Field

From table_Name where Condition(For 51-100 rows);

Then create the chart contaning set analysis with the filter of Field.

Hope this will help.

Re: Help

Mon, 26 Aug 2013 12:45:51 GMT

simply

try rowno() or recno() in script

ex-

load *, rowno() as key,

from table;

******************************

or try this in expression

sum(if(key<=5,fieldname))

or try this

sum(if(rowno()<=5,fieldname))

Re: Help

tresB — Mon, 26 Aug 2013 12:54:29 GMT

See here,

Load Sum(If(Recno()<5,Field)) as Sum; // this will give you sum of first 4 values, i.e - 10

Load * Inline [
Field
1
2
3
4
5
6
7
8
9
];

If you have other dimensions as well, you have to use Group By cluase.