Expression changes

Tue, 31 Jan 2017 19:32:28 GMT

I am facing an issue in frond end.there is a pivot table with below Dimension and Expressions

Dimension:

=Pick(Dim, Timeperiod,'Forecast', 'Actual - Planned', 'Forecast - Planned')

Expression:

=Pick(Dim, Sum(Value),

top(Sum(Value), RangeMax(ColumnNo()-1,1)),

Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value

(Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)

I am getting correct result but problem is representation of Object. There is no fields as dimension like 'Forecast','Actual - Planned', 'Forecast - Planned' using pick function.

But i dont want single expression there any other option instead of pick function

i need below Individual Expression in chart as per requirement:

Forecast : top(Sum(Value), RangeMax(ColumnNo()-1,1)),

Actual-Planned: Sum({<Timeperiod = {'Actual'}>}Value)-(Sum({<Timeperiod = {'Planned'}>}Value

Forecast-Planned: (Top(Sum(Value), RangeMax(ColumnNo()-1, 1)))-(Sum({<Timeperiod = {'Planned'}>}Value)

Re: Expression changes

vinieme12 — Tue, 31 Jan 2017 19:55:38 GMT

Dimension use valuelist

Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned')

Expression

If (Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned') ='Timeperiod'

,expressionfortimeperiod,

If (Valuelist ('Timeperiod','Forecast', 'Actual - Planned', 'Forecast - Planned') ='forecast',

Expression for forecast,

...and so on

topic Re: Expression changes in QlikView

Expression changes

Re: Expression changes