Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How do I display those records that have more than one occurrence (same item) with the status of 0.

There are 4 fields in my object:

     Item Number

     Status   (0, 1, Null)

     Item Discription

     Vendor

I want to disply only those records that have more than one occurrence (same item number) with the Status of 0.   Do you know of an easy way to do that? 

1 Reply
Not applicable

How do I display those records that have more than one occurrence (same item) with the status of 0.

you need to create a new field with an "IF" condition, this new field will contain just what you placed in your "IF" condition.

Greetings!!