Pivot table expression

Thu, 16 Jun 2011 07:53:53 GMT

Hi All,

I have a requirement where in the pivot table I need to show the Actuals and Planned regional wise month on month…

For actual : =(sum({<[Travel Mode] = {'Flight'}>}([Net Fare]))+ sum({<[Travel Mode] = {'Flight'}>}REC_AMOUNT))/1000000. Here I have different modes of travel.so inorder to differentiate I have given the travel mode as Flight in the set analysis.

I have been provided with the actual values regional wise in the below format for the flight alone.

For Planned : I have used the following expression : =aggr(only(Trip_Targets),Month,Month_Trip,[Contract Region] )

I should get the values of the corresponding months in the above first table in the pivot table. But I don’t know where its going wrong.Please look into this and let me know if u have any solution for this….

topic Pivot table expression in QlikView

Pivot table expression