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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Pivot Table

Hi

In my QV document I have a pivot table like given below

FMonth_YearREVENUECOST
Jul-2015197,629,999115,393,118
Aug-2015205,184,56290,634,108
Sep-2015205,310,127118,830,858
Oct-2015213,414,146116,829,218
Nov-2015210,071,164112,696,709
Dec-2015248,441,458130,523,044
Jan-2016215,390,668113,932,903
Feb-2016222,553,371115,182,775
Mar-2016221,173,065122,596,194
Apr-2016228,302,910112,877,640
May-2016222,898,991116,353,477
Jun-2016231,572,131128,801,425

I want to insert columns in this Pivot table which should be as follows

     

FMonth_YearREVENUERev.IncreaseCOSTCost Increase
Jul-2015197,629,999 115,393,118
Aug-2015205,184,5627,554,56290,634,108(24,759,010)
Sep-2015205,310,127125,566118,830,85828,196,750
Oct-2015213,414,1468,104,019116,829,218(2,001,640)
Nov-2015210,071,164(3,342,982)112,696,709(4,132,509)
Dec-2015248,441,45838,370,294130,523,04417,826,335
Jan-2016215,390,668(33,050,790)113,932,903(16,590,141)
Feb-2016222,553,3717,162,703115,182,7751,249,872
Mar-2016221,173,065(1,380,306)122,596,1947,413,419
Apr-2016228,302,9107,129,845112,877,640(9,718,553)
May-2016222,898,991(5,403,920)116,353,4773,475,836
Jun-2016231,572,1318,673,140128,801,42512,447,948

my expression is as follows

SUM({<DESCRIPTION={'TOTAL_REVENUE'}>}ACTUAL)     // for Revenue

SUM({<DESCRIPTION={'COST'}>}ACTUAL)    // FOR  cost

Pls help me to write expression for revenue increase and cost increse over the last month

Labels (1)
10 Replies
upaliwije
Creator II
Creator II
Author

Thanks all