topic Re: Ignoring second dimension in QlikView

Ignoring second dimension

Mon, 04 Jul 2011 07:17:31 GMT

Hello. Sorry, my english is bad, but I hope I would be understood.

I have one table:

LOAD * INLINE [

a,b,c,d

adam,one,43,one

adam,two,655,one

adam,three,56,two

mor,one,6,one

mor,two,323,two

mor,three,543,two

];

I want to create pivot table like this:

a,b,sum(c) for a dimension ignoring b

adam,one,754

adam,two,754

adam,three,754

mor,one,872

mor,two,872

mor,three,872

I can't write function for this table.

Mon, 04 Jul 2011 07:30:19 GMT

Hi,

you want a pivot table with the result:

adam 754

mor 872

Then your dimension is only 'a' and the expression is 'sum(c)'.

Or you collapse the dimension 'b' in the pivot table by clicking on the column 'a' and saying 'Close the dimensions behind'.

regards

vicky

Mon, 04 Jul 2011 07:38:33 GMT

You should use "Sum(Total" specifying the dimenson to "total-on".

In your case the dimensions should be "a" and "b" and the expression should be "sum(total<a> c)"

Best

Francesco

Mon, 04 Jul 2011 08:11:35 GMT

This is solution for my problem.