LOGICAL HELP

[manu1512]

Hii all,

I am new to qlikview. Can any one help me in identifying logic of following expression?

pick( RowNo(),

Sum ({$<Actuality={'Budget'}, Level3={'EBITDA'}>}[PV GC])/1000000,

Sum ({$<Actuality={'Budget'}, Level2={'EBIT'}>}[PV GC])/1000000,

Sum ({$<Actuality={'Budget'}, Level5={'Controllable costs EKS'} >}[PV GC])/1000000,

Sum ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} Production),

Avg ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} AvailabilityTot)*100,

Sum ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} ProdCost)/Sum ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} Production)*1000,

Sum ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} FreeCashflow),

Sum ({$<DataType={'BU'}, ProdMonth=,ProdYear={$(=Max(Year))}, ProdPeriod={'>=$(=Min(YearPeriod)) <=$(=Max(YearPeriod))'} >} Capex),

)

Regards\

manu

[swuehl]

Basically, the pick() function looks at the first argument, which should be a number N.

Then branches into and executes the N+1th argument.

pick - script and chart function ‒ Qlik Sense

If you Need further help, then please provide context.