Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
joshibabu_are
Not applicable

QoQ variance calculation

hi all,

i want to calculate QoQ Variance in Pivot Table .

if no year is selected it should show Current year(2017) data .

if no year selected its showing correct values  for 2017 Q1 But remaining quarters its showing blank.

i want to display QoQ variance for remaining quarters as well

How to show QoQ Variance for Q2,Q3,Q4.

please find the attached screen shot results for 2017 Q2,Q3,Q4

Formula:Q2 Amount-Q1Amount/Q1 Amount

Thanks,

Joshi

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: QoQ variance calculation

Try this

Only({<Year = {"$(=Max(Year))"}>} Aggr(Sum({<Year = {"$(=Max(Year))"}>}Amount)

/Above(Sum({<Year, Quarter, YearQuarter>}Amount))-1, Division, (YearQuarter, (Text))))

4 Replies
sunny_talwar
Not applicable

Re: QoQ variance calculation

Try this

Only({<Year = {"$(=Max(Year))"}>} Aggr(Sum({<Year = {"$(=Max(Year))"}>}Amount)

/Above(Sum({<Year, Quarter, YearQuarter>}Amount))-1, Division, (YearQuarter, (Text))))

joshibabu_are
Not applicable

Re: QoQ variance calculation

Hi Sunny ,

Thanks for your valuable time .

working in sample but not in my original data...

Thanks,

Joshi

sunny_talwar
Not applicable

Re: QoQ variance calculation

What's the difference between the sample and your original file? I won't know until I see it...

vvvvvvizard
Not applicable

Re: QoQ variance calculation

Please can someone explain this complex expression