Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
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 and DIV listbox filter.

                      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 without year end breakup. DIV values will change.

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

rwunderlich‌; deepakk‌; dvadithala‌; dvqlikview‌;‌ mrkachhiaimp‌; swuehl

3 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

Re: Quarterly growth in straight table

Please do not post your question twice in Qlik Community. One time will do, and we can all see your post in the General Overview anyway. Otherwise you will split the attention of the Community and as a result you may not get the focus & answers you need.

Quarterly growth in straight table

You can still remove one of these identical threads by using the Delete function in the Actions menu and at the top right of the discssion header.

Thank you.

Highlighted
Master III
Master III

Re: Quarterly growth in straight table