topic Re: Qlikview filter in QlikView

Qlikview filter

fjpa121197 — Sat, 16 Nov 2024 03:04:00 GMT

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.

Re: Qlikview filter

olivetwist — Tue, 09 Jul 2019 17:35:55 GMT

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.

Re: Qlikview filter

Brett_Bleess — Wed, 31 Jul 2019 17:33:58 GMT

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