Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I need to make a crosstab or report in QlikView where to show both opening and closing amount together with transaction details.
Is there anyway to do it ?
Please find in the attached Excel an detailed explanation of both the source data and of the desired end result.
The sames questions has been made by iqlik ( with the same Source File )
Try this..
T1:
CrossTable(Date, Value, 2)
LOAD *
FROM
ReportQV.xls
(biff, embedded labels, header is 1 lines, table is Report$, filters(
Remove(Row, RowCnd(CellValue, 1, StrCnd(contain, 'Total'))),
Remove(Row, RowCnd(CellValue, 2, StrCnd(contain, 'Amount'))),
Replace(1, top, StrCnd(null))
)) ;