Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Could someone help me build this script in Qlik Sense?
I have "price" listed on a chronological base and, if the price is equal to previous date record, it should be skipped (dismissed).
Table on the left my source data and table on the right my expected result:
Thanks!
Perhaps like this:
tmpData: LOAD Product, Date, Price FROM ...source_table... ; Result: NOCONCATENATE LOAD Product, Date, Price WHERE Flag =1 ; LOAD Product, Date, Price, If(Previous(Product)<>Product OR Previous(Price)<>Price,1,0) as Flag RESIDENT tmpData ORDER BY Product, Date DESC ; DROP TABLE tmpData;
Perhaps like this:
tmpData: LOAD Product, Date, Price FROM ...source_table... ; Result: NOCONCATENATE LOAD Product, Date, Price WHERE Flag =1 ; LOAD Product, Date, Price, If(Previous(Product)<>Product OR Previous(Price)<>Price,1,0) as Flag RESIDENT tmpData ORDER BY Product, Date DESC ; DROP TABLE tmpData;