topic Re: force distinct? in QlikView

force distinct?

Fri, 20 Jun 2014 02:04:36 GMT

Hi, I have a field called itemnum. if the excel file has many duplicates for one itemnum because of different dates for one itemnum, can i sort of force distinct itemnum in qlikview regardless of the many different date records for one itemnum? Thanks.

Re: force distinct?

Anonymous — Fri, 20 Jun 2014 02:46:10 GMT

How about using COUNT(Distinct itemnum) in expression?

Re: force distinct?

Anonymous — Fri, 20 Jun 2014 02:51:18 GMT

Hi, Rachel.

That depends of your exact requirements. Let's say you want to count the distinct itemnum. It is as simply as using this expression in your charts:

Count(Distinct itemnum).

If you want to load only distinct itemnum, you'll have to ditch the dates. Probably you don't want that. Anyway, the load statement in the script would be:

Load Distinct

itemnum,

[other fields that aren't different for one itemnun]

From file.xls....

Hope it answers your doubts.

Regards.

Re: force distinct?

rwunderlich — Fri, 20 Jun 2014 03:03:12 GMT

You'll probably want to do the distinction at load time like:

Items:

LOAD

ItemNum

,max(ItemDate) as ItemDate

, ItemNum

FROM...

GROUP BY ItemNum, ItemNum

;

-Rob