Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a table with duplicate values in on column.
I need to do some logic for duplicate records.
this is my table
This the Output i need.
How to do this using load script or set analysis?
LOAD *, if(Item=Peek(Item) and Qty=Peek(Qty),0,Qty) as RevisedQty;
load * Inline [
Item Qty Cost
Item1 1 100
Item1 1 101
item2 1 200
item3 2 300
] (delimiter is \t);