Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Synthetic dimension functions - Valuelist

Hi Guys,

I wanted to try and use valuelist inside an aggr if function...this didnt work. My expression looked like this

Aggr(if(CostCentreType='Operations',Valuelist('Revenue','Cost of Sales','Margin','Margin %'),Valuelist('EBIT')),CostCentreType)

What I am trying to achieve is that if CostCentreType (It has been added as a dimension) is 'Operations', then use the first valuelist, if CostCentreType is something else use the 2nd Valuelist which is just 'EBIT'

Any idea how to get this to work and where I am going wrong


Tags (1)
Community Browser