Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I need Formula in Qlikview which is to be derived using Excel Formula.
Urgent Help required. No one has given correct answer for this Scenario.
Accepted Solutions
Check this out
Table:
LOAD RowNo() as Sort,
Product,
TranDate,
Flag,
Credit,
If(Product = Peek('Product'), 1, 0) as Flag1,
If(Flag = 'Yes', 1, 0) as Flag2
FROM
[Required Formula in Qlikview.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Sheet1)
Where Len(Trim(Credit)) > 0;
NewTable:
LOAD *,
If(Product = Peek('Product'), 1, 0) as Flag3
Resident Table
Order By Sort Desc;
DROP Table Table;
FinalTable:
LOAD *,
Alt(If(Flag1 = 1 and Flag2 = 0, Peek('ReqCol'),
If(Flag2 = 1, Credit,
If(Flag3 = 0, Peek('ReqCol')))), 0) as ReqCol
Resident NewTable
Order By Sort;
DROP Table NewTable;
