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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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