Discussion Board for collaboration related to QlikView App Development.
I have two feilds coming from the same table
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???
May be this:
LOAD Purchase Tag,
Count(Asset No) as CountCheck
Group By Purchase Tag;