topic How to write count(distinct feild) in data model script level in QlikView

How to write count(distinct feild) in data model script level

Thu, 21 Jan 2016 05:03:21 GMT

I have two feilds coming from the same table

Table1:

Id,

Purchase Tag,

Asset No

I want to find out the duplicates in Purchase tag.

Ideally for a particular purchase tag only one asset no should be mapped.

If for the same purchase tag, more than one asset no is tagged means, it is a deviation and i need to highlight those issues.

How to highlight those issues???

sunny_talwar — Thu, 21 Jan 2016 17:48:53 GMT

May be this:

Table1:

LOAD Id,

Purchase Tag,

Asset No

FROM

Join (Table1)

LOAD Purchase Tag,

Count(Asset No) as CountCheck

Resident Table1

Group By Purchase Tag;