This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Greetings. I'm interested in aggregate some lines of a table in frontend.
Imagine that i have the following situation:
Field1 | Area
Building A1 | 100
Building A2 | 110
Building A3 | 120
Building A4 | 130
Building B1 | 105
Building B2 | 115
Building C1 | 80
Building C1 | 150
and i want to have a final result like:
Field1 | Area
Building A | 460
Building B | 220
Building C | 230
Thanks in advance, hope you can help me.
View solution in original post
you can usa a calculated dimension. In this case it would be Left(Field1, Len(Field1) - 1) and Sum(Area) as expression.
that is a very particular case. What if the words doesn't have the same size... Like, House A1, Apartment A2, Villa A3, and so on... How do i put all these fields as Buildings A for example?
that might be a bit difficult. But it looks like you have pattern like [WordWithDiffenentLength][BLANK][GROUPwithFIXLength][SubGroup]. If so you can use
Left(Field1, Index(Field1, ' ') + [LengthOfGroup])
Left(Field1, Index(Field1, ' ') + 1) 1 for A,B,C
just a hint, you should use that logic to create an additional field in your data moddel, because calculated dimensions are quite heavy to calculate.
Left(Field1, Index(Field1, ' ') + 1) as AggreagateGroup
to your table and use AggreagateGroup as Dimension to improve the chart calcualtion performance