Discussion board where members can get started with QlikView.
I have a data set :
Can make a pivot table likes below? I'm no idea how to do Opening & Closing Balance.
Thanks for any help.
Could you provide us with the data in excel?
Thank you first. Please find the attached Excel file.
Year(Date#(fselldate, 'YYYYMMDD')) as Year_sell,
Year(Date#(fexpdate, 'YYYYMMDD')) as Year_exp,
1 as Issued,
if(Len(Trim(freddate)) = 0, 0, 1) as Redamption
(ooxml, embedded labels, table is Sheet1);
I got a little further but I couldn't manage to understand the login behind Opening and Expire expressions.
Could you collaborate on the algorithm?