Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.