What i am trying to show in a chart are any rows of data where Article ID 2 appears on its own receipt with no other Articles

[Anonymous]

Hi,

I am a Qlikview novice and need some help on what seems a simple task:

Within my data table i have the below fields. What i am trying to show in a chart are any rows of data where Article ID 2 appears on its own receipt with no other Articles. e.g receipt 200 & 400. This is to enable me to identify any operator who is putting through Article ID 2 or so they can potentially take money out of the till come the end of their shift.

Operator, Receipt No, Article ID, Price

John, 100, 5, £1.50

John, 100, 4, £1.99

John, 100, 3, £1.99

John, 100, 2, £0.05

Sally, 200, 2, £0.05

Roger, 300, 1, £2.99

Roger, 300, 2, £0.05

Roger, 300, 5, £1.50

Vicky, 400, 2, £0.05

If anyone could help that would be great.

Thanks

[sunny_talwar]

May be using set analysis:

{<[Receipt No] = {"=[Article ID] = 2"}>}

[Siva_Sankar]

Adam,

I'm not sure whether the attached application works good for you. I got it from quick intelligence blog.. take a look

Regards,

Siva

[marjan_it · Accepted solution]

u can use this in dimention in chart.

=IF(Aggr(Count(DISTINCT [Article ID]),[Receipt No])=1 and [Article ID]=2,[Receipt No])