Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

3 Replies
Not applicable
Author

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
Author

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
Author

This is solution for my problem.