topic Re: How Convert Record To Column and Calculate Difference in QlikView

How Convert Record To Column and Calculate Difference

Tue, 18 Aug 2015 15:55:33 GMT

hello Dears

i have One Table Look Like

I would like to give the following

sunny_talwar — Tue, 18 Aug 2015 15:57:16 GMT

Check 'Horizontal' on the Presentation tab:

Miguel_Angel_Baeyens — Tue, 18 Aug 2015 15:58:35 GMT

Hi,
GENERIC LOAD is likely what you are looking for. See here for more info:

Miguel

sunny_talwar — Tue, 18 Aug 2015 15:59:02 GMT

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?

Tue, 18 Aug 2015 16:02:10 GMT

Thanks How To Calculate Automatic Difference

2005-2006

2006-2007

2007-2008

...

Tue, 18 Aug 2015 16:07:51 GMT

yes

but years is dynamic 2005,2006,2007,?

sunny_talwar — Tue, 18 Aug 2015 16:22:03 GMT

This looks good (Just need a better sorting):

Script:

Table:

LOAD * Inline [

Year, Value

2005, 10

2006, 20

2007, 30

2008, 40

];

Concatenate (Table)

LOAD If(Previous(Year) > 0, Year & '-' & Previous(Year)) as Year,

If(Previous(Value) > 0, Value - Previous(Value)) as Value

Resident Table;