LOGICAL HELP

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: LOGICAL HELP

swuehl — Mon, 20 Nov 2017 16:07:08 GMT

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.

topic LOGICAL HELP in QlikView

LOGICAL HELP

Re: LOGICAL HELP