Discussion Board for collaboration on QlikView Scripting.
I need the help of somebody.
I have a table of consumption like this:
I need to group the table in a tabla of interval like this:
Thanks in advance.
I attached the excell file too.
Go to Solution.
Hi, this script cn create that table:
DataOrig:LOAD Consumption,SupplierFROM[.\Consumption.xlsx](ooxml, embedded labels, table is Hoja1);
tmpData:LOAD Consumption as Initio,If(Supplier=Peek(Supplier), Peek(Fin), Peek(Initio)) as Fin,SupplierResident DataOrig order by Consumption desc;
FinalData:NoConcatenateLOAD *Resident tmpDataWhere Peek(Supplier)<>SupplierOrder by Initio;
DROP Table DataOrig;DROP Table tmpData;