Discussion Board for collaboration on QlikView Layout & Visualizations.
i have which is like a Date field it showing n Number of dupicates and in script level i used load Distincrt also. XYZ
sorry boss it not working
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:
floor(XYZ) as XYZ
Thank for uer reply
it not working man