Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to eliminates the dupicates in stright table

Dear all

   i have which is like a  Date field  it showing  n Number of dupicates  and    in script level  i used  load Distincrt  also. XYZ 

XYZ

09-09-2010

09-09-2010

09-09-2010

Regards

surik147

Tags (2)
4 Replies
Not applicable

Re: How to eliminates the dupicates in stright table

hi

use count(distinct(xyz))

thanks

Not applicable

Re: How to eliminates the dupicates in stright table

sorry boss it not working

Re: How to eliminates the dupicates in stright table

Make sure you're dates don't have time fractions or they will be distinct even though the date parts are the same. You can use the floor function to cut of the time fractions:

load distinct

floor(XYZ) as XYZ

from ....


talk is cheap, supply exceeds demand
Not applicable

Re: How to eliminates the dupicates in stright table

Thank for   uer reply

it  not working man

Community Browser