pick function + concatinate to field object

Anonymous — Mon, 24 Jun 2013 13:10:01 GMT

Hi,

Is there a way to make this a one liner instead of rerwite this 12 times?

pick

([COST Claim Repair Age Year]
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year1] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year2] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year3] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year4] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year5] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year6] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year7] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year8] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year9] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year10] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year11] ), [COST Claim Repair Age Year])
,aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >} [CONTRACT Main Contract In Year12] ), [COST Claim Repair Age Year]

)
)

Re: pick function + concatinate to field object

Anonymous — Mon, 24 Jun 2013 13:53:02 GMT

If I understand correctly what you want, it is:

aggr(NODISTINCT sum( {$<[COST Main Operation No1]={"*"}, [COST Main Operation No2]={"*"}, [COST Main Operation No3]={"*"}, [COST Main Operation No]={"*"} >}

pick([COST Claim Repair Age Year], [CONTRACT Main Contract In Year1] ,[CONTRACT Main Contract In Year2] , ...[CONTRACT Main Contract In Year12] )

), [COST Claim Repair Age Year])

(Count my paretnthesis please)

Regards,

Michael

Re: pick function + concatinate to field object

Anonymous — Mon, 24 Jun 2013 15:00:24 GMT

Yes, something like that. But when I change it this way the result is not the same anymore.

Re: pick function + concatinate to field object

Anonymous — Tue, 25 Jun 2013 19:29:46 GMT

Can't see why. If you upload a sample application I (or someone else) will take a look.

topic pick function + concatinate to field object in QlikView

pick function + concatinate to field object

Re: pick function + concatinate to field object

Re: pick function + concatinate to field object

Re: pick function + concatinate to field object