Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Ignoring second dimension

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.

1 Solution

Accepted Solutions
Not applicable

Ignoring second dimension

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

3 Replies
Not applicable

Ignoring second dimension

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

Not applicable

Ignoring second dimension

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

Not applicable

Re: Ignoring second dimension

This is solution for my problem.

Community Browser