Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set analysis for growth

Hi All,

I want to calculate the growth of a item.

Current year,selected month vs Previous year selected month

Please let me know was I am doing that in right way?


(Sum({$<YEAR={$(=Max(YEAR(TranDate)))},MONTH={$(=Max(Month(TranDate)))}>} Qty) / Sum({$<YEAR={$(=Max(YEAR(TranDate))-1)},MONTH={$(=Max(MONTH(TranDate))-1)}>} Qty))*100-100


Tags (2)
2 Replies
Not applicable

Set analysis for growth

Hi All,

I have given the selected field and expression of my pivot table.

What exactly I want to calculate is to what is the growth of month when compared to the previous year of the same month.

Some one please let me know whats wrong with this Set Analysis! I am not getting any values in the growth expression.


Dimension:

ZM

ItemName

=MonthName(TranDate)

Expressions:

(Sum({$<YEAR={$(=Max(YEAR(TranDate)))},MONTH={$(=Max(Month(TranDate)))}>} Qty) / Sum({$<YEAR={$(=Max(YEAR(TranDate))-1)},MONTH={$(=Max(MONTH(TranDate))-1)}>} Qty))*100-100


Not applicable

Set analysis for growth

Hi All,

Have attached the document to work on. Hope some one can provide me the solution.

Community Browser