Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

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

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???

1 Reply

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

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;