I need to be able to show graphical data, in quarterly time buckets. The data I am getting is in monthly buckets and is in tabular format so not ideal to import into QLIK. So I'm thinking best solution would be to convert monthly to quarterly data using a cross table - example of what I mean below :
I have tried to do this but not really and the cross table works but the summing up into quarters doesn't. Any advise on if this is the right/best approach or how to do this would be most gratefully received !
Many Thanks ! I can follow your script but my QLIK "grammar" is not really up to scratch yet !
I have tried to adapt this code to load the source data from Excel file - as opposed to an in-line table load , but without success - my script to load excel table is as follows, I get a "field company not found"....