Discussion Board for collaboration on QlikView Layout & Visualizations.
i have One Table Look Like
I would like to give the following
Go to Solution.
This looks good (Just need a better sorting):
LOAD * Inline [
LOAD If(Previous(Year) > 0, Year & '-' & Previous(Year)) as Year,
If(Previous(Value) > 0, Value - Previous(Value)) as Value
Check 'Horizontal' on the Presentation tab:
Hi,GENERIC LOAD is likely what you are looking for. See here for more info:
The Generic Load
How convert table from rows to columns
Just realized that you need to calculate delta also. It will be easy to add a value for change in the script. A script based solution works?
Thanks How To Calculate Automatic Difference
but years is dynamic 2005,2006,2007,?