Discussion Board for collaboration related to Creating Analytics for QlikView.
I have sample data associated as below.
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
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.
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;
(html, codepage is 1252, embedded labels, table is @1, filters(
Remove(Row, Pos(Top, 1))
Check the sample attached here -
Re: QoQ Growth calculation using multiple dimensions in StraightTable