Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
camjvine18
Contributor

Create a new field for a duplicate

New field = Duplicate to be either Yes or No

If the "P_L Unrealised USD" for the next 3 Files equal the same value then mark all files following this as a duplicate.

In the attached App, bookmark SM2 example all files, any files beyond Futures Log_171213 with value Unit 1 = 1,486, Unit 2 = 1,253 should be marked as a duplicate but this will be decided after Futures Log_171215, ie. after the 3rd time it appears. !