Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
fjpa121197
Contributor II
Contributor II

Qlikview filter

Hi, I have a question about group by of repeated values. 

 

I have a table that gives me repeated values, however, I made a relation that A is equal to AA,AB,AC, but when displayed in a table, it shows me A three times (values from AA, AB,AC), but i want to see only one A, but with the sum of AA,AB,AC. 

Im using a straight table.

Labels (3)
1 Solution

Accepted Solutions
olivetwist
Creator
Creator

If all of your associations are such that the A = AA,AB,AC and B = BA,BB,BC etc. you should just add a field during load:

Load

....

Left(Field1,1) as Group_Filter

....

from xyz.xls;

 

or something like that.

View solution in original post

2 Replies
olivetwist
Creator
Creator

If all of your associations are such that the A = AA,AB,AC and B = BA,BB,BC etc. you should just add a field during load:

Load

....

Left(Field1,1) as Group_Filter

....

from xyz.xls;

 

or something like that.

Brett_Bleess
Former Employee
Former Employee

Did the above poster's response solve your issue?  If so, please be sure to click the Accept as Solution or confirm in a chat reply, so we can mark it.  If not, please provide further information.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.