Discussion board where members can get started with QlikView.
Hello. Sorry, my english is bad, but I hope I would be understood.
I have one table:
LOAD * INLINE [
I want to create pivot table like this:
a,b,sum(c) for a dimension ignoring b
I can't write function for this table.
Go to Solution.
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)"
you want a pivot table with the result:
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'.
This is solution for my problem.