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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

delta in line chart

Hello,

I have a DB like so:

CALLING_MSISDN,      CALL_DATE,                WEEK,                PREMIUM_RATE

     1                              ,07-05-2016,              18-2016,                     3

     1                               ,08-05-2016,             18-2016                       5              

     1                              ,11-05-2016,               19-2016                     10

     2                              ,18-05-2016,               20-2016                     15    

     2                              ,23-05-2016,               21-2016                      5

......

I use a pivot table to show me the delta and delta% between the different weeks using this function:

IF ( RangeSum (Below(sum(PREMIUM_RATE)))<> 0, (sum(Total < CALLING_MSISDN, WEEK> PREMIUM_RATE) - RangeSum (Below(sum(PREMIUM_RATE))))/

sum(Total < CALLING_MSISDN, WEEK> PREMIUM_RATE)

, '')

CALLING_MSISDN WEEK PREMIUM_RATEDeltaDelta %
05XXXXXXX22-2016₪ 119.27₪-261.63-219.36%
21-2016₪ 380.90₪-70.73-18.57%
20-2016₪ 451.63₪ 96.2121.30%
19-2016₪ 355.42₪ 165.2346.49%
18-2016₪ 190.19₪ 166.9287.76%
17-2016₪ 23.27

I want to display the delta % on a graph (line chart). So that I will see the weeks on the buttom and the % change  on the Y axis.

How can I do that?

Thank you

0 Replies