topic Re: Ranngesum not working in pivot table when only one expression is written in QlikView

Ranngesum not working in pivot table when only one expression is written

Fri, 20 Mar 2015 08:37:59 GMT

Hello Everyone,

When using only one expression in pivot table the data doesn't get displayed. But when second expression is written the chart gets populated.

The requirement is that:

SS	Month	diseng
SS1	june 2013	10
SS1	july 2013	13
SS1	aug 2013	10
ss2	june 2013	1
ss2	july 2013	2
ss2	aug 2013	3

NOw i want to count the cumulative disengagements for SS. in pivot table.

like For value SS1,for the month of june2013,disengcount=10
and for the same SS1 FOR THE MONTH OF JULY 2013, it should be (13+10)=23.
i want this to be represented in pivot table by transposing the month .

Can anyone help on this?

Regards,

Pratik

Re: Ranngesum not working in pivot table when only one expression is written

Gysbert_Wassenaar — Fri, 20 Mar 2015 08:45:09 GMT

See attached qvw.

Re: Ranngesum not working in pivot table when only one expression is written

Fri, 20 Mar 2015 10:24:54 GMT

Hey Gysbert,

Thanks for the reply.

Actually I also tried in the same manner but after giving the expression the chart not used to get populated, because of the before function I guess. Then after giving the additional expression of ColumnNo() the chart got populated and eventually after transposing the additional column was introduced.

So now I transposed first and then gave the expression then it worked.

What was the sequence you followed?

Thanks for your reply.

Cheers!

Pratik

Re: Ranngesum not working in pivot table when only one expression is written

Gysbert_Wassenaar — Fri, 20 Mar 2015 10:30:40 GMT

Kind of. I added an expression =1 and removed it again after pivoting.

Re: Ranngesum not working in pivot table when only one expression is written

Fri, 20 Mar 2015 10:37:52 GMT

I thought so.