Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

opening and closing amount together with transactions

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 )

1 Reply
settu_periasamy
Master III
Master III

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))
)) ;


Capture.JPG