topic Removing duplicates in Straight Table in QlikView

Removing duplicates in Straight Table

Tue, 10 Mar 2015 08:59:22 GMT

Hi,

I have data in straight table and don't want duplicate are repeated in each and every row, at the same time don't want to use pivot table. Pls find the attached sample data and I am using personal edition.

Sample data contains source data and expected output data as well, kindly let me know the best solution.

Thanks,

Re: Removing duplicates in Straight Table

senpradip007 — Tue, 10 Mar 2015 09:00:57 GMT

Use Pivot chart you will reach your desired result.

Re: Removing duplicates in Straight Table

senpradip007 — Tue, 10 Mar 2015 09:03:51 GMT

PFA.

Re: Removing duplicates in Straight Table

Tue, 10 Mar 2015 09:21:19 GMT

Hello Pradip,

I am using person edition, so not able to open that and I don't want pivot table.

Thanks,

Re: Removing duplicates in Straight Table

Anonymous — Tue, 10 Mar 2015 09:35:15 GMT

Is there any particular reason to not use Pivot table ? .. because your requirement is fit for Pivot.

Re: Removing duplicates in Straight Table

Tue, 10 Mar 2015 10:11:17 GMT

I agree Chand in fact I did it in Pivot table, but I will to have give proper reason why it is not implemented in Straight Table. Is this feature not available in straight table.

Thanks,

Re: Removing duplicates in Straight Table

Tue, 10 Mar 2015 10:30:23 GMT

Hi,

Hope this will be helpful :Straight Tables - Remove Duplicate Row Labels

chart properties -> dimensions -> click on the repeated dimension -> set 'text color' as

=IF(Dim_name = Above(Dim_name), White())

( set the text color same as background color of ur straight table)

Note - You can only able to disappear the repeated values. For Merging col/rows you have to try in pivot table only.. As I know there is no other way around!...

Regards

lathaa

Re: Removing duplicates in Straight Table

Tue, 10 Mar 2015 11:19:23 GMT

I tried, looks like not working.

Thanks,

Re: Removing duplicates in Straight Table

Thu, 12 Mar 2015 02:25:52 GMT

Hi Madu Raj,

Can you send me your .qvw file. so that I'll check your case and will tell you the work around way to achieve your requirement.....

Regards

Lathaa

Re: Removing duplicates in Straight Table

Fri, 13 Mar 2015 13:57:56 GMT

Hey latha,

I believe this is possible pivot table not with straight table.

Thanks,

Re: Removing duplicates in Straight Table

Mon, 16 Mar 2015 02:43:19 GMT

Yeah, but still u can do some sort of formatting tricks to make it fit to your requirement.But It will not be the perfect one as Pivot table.

Regards

Lathaa

Re: Removing duplicates in Straight Table

timanshu — Tue, 17 Mar 2015 09:03:33 GMT

Hi Madu,

Just go for Pivot table. You can clearly convey Pivot table is meant for what straight table can't do.

Re: Removing duplicates in Straight Table

Mon, 23 May 2016 18:20:34 GMT

Hello, I have the same requirement, remove duplicated dimension labels as well as remove duplicated expressions values.
I cannot use Pivot chart because I have a sort requirement that cannot be done in pivot. I cannot use the Above function either because it makes all my expressions returning - instead of a value.

I tried different things like reloading the data as resident but the straight table always duplicate the labels and values.

i.e.
Product Inventory Customer Sales

A 10 B 20

A 10 C 30

B 20 B 40

B 20 D 50

Should be

Product Inventory Customer Sales

A 10 B 20

C 30

B 20 B 40

D 50

Re: Removing duplicates in Straight Table

Supriya — Tue, 12 Nov 2019 04:38:42 GMT

Hi All,

I have also got a similar requirement. Is there any way we can achieve this