Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table expression

Hi All,

   

Hi

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….

0 Replies