topic Re: Total of Rows in QlikView

Total of Rows

Tue, 04 Mar 2014 14:19:26 GMT

I have the following straight table which gives me no of days each stage is taking for applications. In the expression for Total I am saying "Stage 1" + "Stage 2" + "Stage 3" + "Stage 4". It only works if there is no dash (- ) in the row i.e. Loan. How can I get total of the rows which include dash (- ) in it i.e. Overdraft and Masterplan rows? Or should I convert - into 0???

No of days
Product	Stage 1	Stage 2	Stage 3	Stage 4	Total
Loan	1	2	3	2	8
Overdraft	2	-	2	5	-
Masterplan	3	4	2	-	-
	6	6	7	7	8

Re: Total of Rows

m_woolf — Tue, 04 Mar 2014 14:55:50 GMT

Try:

Sum(Stage1) + Sum(Stage2) + ...

Re: Total of Rows

Tue, 04 Mar 2014 15:08:28 GMT

Thanks Michael. I tried Sum("Stage1") + Sum("Stage2")+.... but it did not work. Stage1, Stage 2, .... are expressions label

Re: Total of Rows

Tue, 04 Mar 2014 15:09:58 GMT

Also sorry I have pivot table

Re: Total of Rows

Tue, 04 Mar 2014 15:10:58 GMT

The dash represent null() or missing data

And a number + a null = null : the null propagates

Use rangesum() instead: with that function, the null is not propagated

rangesum(A, B, C) = A+B+C (all null values are treated as 0

Fabrice

Re: Total of Rows

Tue, 04 Mar 2014 15:20:37 GMT

Hi Aunez,

Really apprecited your help. Basically application can go in any stage and can skip any stage. So you are saying if application does not go in any stage then it will result in - . How can I skip this dash in pivot table. I could not understand whats you said that "And a number + a null = null : the null propagates"???

Re: Total of Rows

Anonymous — Tue, 04 Mar 2014 15:23:06 GMT

try [Stage 1]+[Stage 2]+[Stage 3]+[Stage 4]

Re: Total of Rows

Tue, 04 Mar 2014 15:32:44 GMT

In presentation tab, you have textboxes to handle the null display

In QV, if you want to sum several datas with the + sign, if one of these data (in one field, in one expression) is null, then the global result will be null => the null propagates

Fabrice