topic fill on calculated field in QlikView

fill on calculated field

Thu, 27 Jan 2011 13:04:32 GMT

Hi All

I've been playing around with an excel file which i use in one of my files and trying to get Qlikview to deal with a column on it's own as apposed to me adding a definitions column.

I'm trying to load a spreadsheet which contains something like below:

		month 1	month 2	month 3	month 4	month 5
	Actual
Actual	Product 1	x	x	x	x	x
Actual	Product 2	x	x	x	x	x
Actual	Product 3	x	x	x	x	x
	Plan
Plan	Product 1	x	x	x	x	x
Plan	Product 2	x	x	x	x	x
Plan	Product 3	x	x	x	x	x

Currenlty i'm having to put in the Actual/ Plan column manually in to the spreadsheet. I can create a calculated line which recognises where actual and Plan are. The problem i am having is trying to get this to fill further down the list. For the second line it's not a problem using "Previous" or "Peek" but for the third it doesn't work. I have also tried to use the data transformation tool in the wizard but it does not recognise the calculated column as being "real".

Any help would be greatly appreciated.

Thanks

Michel

fill on calculated field

matt_crowther — Thu, 27 Jan 2011 13:26:09 GMT

Michel,

Try looking at top() - refers to the top record and above() as this can be controlled with a value ie the value n rows above not just the previous.

Hope that helps,

Matt - Visual Analytics Ltd

fill on calculated field

Thu, 27 Jan 2011 14:33:30 GMT

Hi Matt

Thank you for coming back to me. Should i be able to use the Top function in the load script or should this be in the object i am defining? I've tried to put it into the script and it doesn't seem to like it. Sorry to be a pain.

Thanks

Michel