topic Re: Removing the duplicates in QlikView

Removing the duplicates

sivarajs — Fri, 19 Jul 2013 06:57:55 GMT

Hi,

I have table like below

Field A	Field B	Field C	Field D
1	xyz	rec	456
2	xyz	rec	456
3	xyz	rec	456
4	xyz	rec	456
5	xyz	rec	456
6	xyz	rec	456

Its a staight table and am hiding Field A. Because of that it shows all the rest of records. Without Field A it looks the values are repeating.

Field B	Field C	Field D
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456
xyz	rec	456

Is there any workaround to show rest as single record.

Field B	Field C	Field D
xyz	rec	456

Thanks,

Sivaraj

Re: Removing the duplicates

Fri, 19 Jul 2013 07:05:15 GMT

Sum(DISTINCT [Field D])

or in presentation tab > check Max no show(1)

Re: Removing the duplicates

tresB — Fri, 19 Jul 2013 07:17:58 GMT

In expression tab put a dummy expression '=1' and hide it in the presentation tab. Now instead of hiding your Field A in the presentation tab, put an enable condition (Dimension tab) as 0 (i.e - 'FALSE' for always).

Hope this gives you an idea.

Re: Removing the duplicates

sivarajs — Fri, 19 Jul 2013 07:23:06 GMT

Hey thanks for your response i dint work

Re: Removing the duplicates

Fri, 19 Jul 2013 07:41:15 GMT

in straight--

in dimension tab-

select the [Field A]

then check the Enable condition and write its value is 0.

then output like this

see attachment

Field B	Field C	[Field D]
xyz	rec	456

Re: Removing the duplicates

neetu_singh — Fri, 19 Jul 2013 07:47:59 GMT

Hi,

Can you elaborate your problem as are you doing summation or want to pick only value.

Regards

Neetu Singh

Re: Removing the duplicates

sivarajs — Fri, 19 Jul 2013 08:20:18 GMT

Hi vishwa,

When i enable condition as 0 it showing only single record for entire table.Table has same type of other records as well