topic Re: Trying to get previous in QlikView

Trying to get previous

rcorcoran — Wed, 07 May 2014 11:21:45 GMT

I am trying to put this in the script to have a field showing outturn as the previous year to the year selected. Can anyone help??

Thanks

if(MetricKey =10 and ReferredMM=12 and ReferredYYYY= (ReferredYYYY)-1,MetricKey) as Outturn

Re: Trying to get previous

tresB — Wed, 07 May 2014 11:38:35 GMT

This is not enough information to help you. However, I guess you if you are thinking of joining the new field to the existing table, you have to basically use the following logic:

Table1:

Load

Year,

Data

From <>;

Join

Load

Year-1 as Year

Data as PreData

Resident Table1;

Re: Trying to get previous

rcorcoran — Wed, 07 May 2014 12:12:50 GMT

I am sorry but I have a table as follows

I want the table to show a field before January only that has the figure from the December of the previous year in it as an out turn figure. I have tried to put it in expressions but it shows up as a column beside each month with the figures at the end in for december but I just want 1 column with the december figure in it before January.

Thanks

ServiceProvider	Month	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec
Adelaide & Meath Hospital Inc NCH (HIPE)		28.6	31.6	27.4	21.4	16.0	16.9	15.9	18.8	20.3	15.1	16.9	13.0
Bantry General Hospital		12.6	14.3	13.4	21.9	83.3	9.5	15.4	12.3	12.8	13.5	14.9	35.1
Beaumont Hospital		41.2	37.3	34.2	27.8	23.3	25.2	23.5	22.4	19.4	18.1	20.3	21.7
Cappagh National Orthopaedic Hospital		7.0	37.5	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
Cavan General Hospital		15.0	15.4	15.8	10.1	10.6	10.7	11.7	10.9	10.2	11.0	10.3	10.6
Children's University Hospital Temple Street		9.3	5.4	7.6	6.1	3.5	3.9	2.9	3.0	4.5	4.0	4.3	4.7

Re: Trying to get previous

tresB — Wed, 07 May 2014 12:16:34 GMT

So you are using a pivot table. To achieve the same, a bit of script work would be required. try to post your sample app with sample data as INLINE. That would be fastest way to be helped.