Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Quarterly growth in straight table

I have sample data associated as below.

DIMENSIONSEXPRESSION

DIV

REPORT_YEAR

REPORT_QUARTERD_MONTHAMOUNT
101995091995071995100
101995091995081995150
101995121995071995200
101995121995081995100
101996031996071995300
101996031996081995350
101996061996081995400
101996061996091995450
101996061996111995500
101996091996011995550
101996091996061995600
101996091996081995650
101996091996091995700
101996091996101995750
101996091996111995800
101996121996081995500

I want to calculate Quarterly growth AMOUNT for each quarter of 'REPORT_QUARTER' based on maximum of 'D_MONTH' for all years of 'REPORT_YEAR' based on dimensions DIV, REPORT_YEAR, REPORT_QUARTER.

I want to display the result data in straight table as below. With below REPORT_YEAR, QUARTER multibox filter (sample).

                                     Output Table required

Multibox Filter
(For understdng, not to display in table)
        DimensionsExpression

REPORT

_YEAR

REPORT

_QUARTER

DIVD_MONTHAMOUNT

Quarterly

GROWTH

Calculation

for understanding

199509199510071995100     -
199509199510081995150     -
199512199510071995200     -
199512199510081995100-50(100-150)
199603199610071995300     -
199603199610081995350250(350-100)
199606199610081995400      -
199606199610091995450      -
199606199610111995500150(500-350)
199609199610011995550      -
199609199610061995600      -
199609199610081995650      -
199609199610091995700      -
199609199610101995750      -
199609199610111995800300(800-500)
199612199610081995500-300(500-800)

If user select year '1995', user should be able to see Quarterly GROWTH of -50 which is based on latest D_MONTH '081995' of REPORT_QUARTER's 091995 & 121995, likewise for other years.

Can anybody please help. Thanks in Advance. Thanks for your time.

2 Replies
Highlighted
Contributor III
Contributor III

Re: Quarterly growth in straight table

Note: I cannot paste screenshot or developed application due to environment restrictions and confidentiality of data.

You can take the above table data as.

Load *,MakeDate(Right(D_MONTH,4),left(D_MONTH,2)) as DATE;

LOAD DIV,

     REPORT_YEAR,

     REPORT_QUARTER,

     D_MONTH,

     AMOUNT

FROM

// [https://community.qlik.com/thread/260354]

(html, codepage is 1252, embedded labels, table is @1, filters(

Remove(Row, Pos(Top, 1))

Highlighted
Master III
Master III

Re: Quarterly growth in straight table