topic Re: Find the Quarter wise % values in QlikView

Find the Quarter wise % values

Lakshman_1031 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 3 years and having Quarters.

How to calculate the percentage values in Quarter wise.

I have used Sum(Sales)/$(vSales)

Note: vSales ==Sum({<Quarter=,Month=, Year=>}Sales).

If i select the one percentage values are changed.

for example if i select 2019 then Quarters % values are changed. then clear it will change % values.

How to find the correct % values for Year wise and over all.

please find the below example for your reference.

please suggest me how to achieve this scenario.

Thanks & Regards,

lakshman

Re: Find the Quarter wise % values

tresB — Tue, 25 Feb 2020 10:24:34 GMT

Like this?

vSales =Sum(TOTAL {<Quarter=,Month=, Year=>}Sales).

Re: Find the Quarter wise % values

Lakshman_1031 — Tue, 25 Feb 2020 11:10:00 GMT

Hi Tresesco,

Thanks for your Quick response.

i have used Sum(TOTAL {<Quarter=,Month=, Year=>}Sales).

but Year wise values are wrong.

for example year 2020 and Q 1 having 23.9 but in chart having 8 %.

please see the below example for your reference.

Please suggest me how to achieve this scenario.

Thanks & regards,

Lakshman

Re: Find the Quarter wise % values

sunny_talwar — Tue, 25 Feb 2020 12:02:47 GMT

Try this

Only({<Quarter, Month, Year>} Aggr(NODISTINCT Sum({<Quarter, Month, Year>} Sales), Year))

Re: Find the Quarter wise % values

tresB — Tue, 25 Feb 2020 13:30:14 GMT

Or, try this:

vSales = Aggr( NODISTINCT Sum({<Quarter=,Month=, Year=>}Sales),Year)

Re: Find the Quarter wise % values

alex00321 — Wed, 26 Feb 2020 06:46:17 GMT

Thanks for the reply expert! Why we use only given it's still working after removing it? Thanks!

Re: Find the Quarter wise % values

sunny_talwar — Wed, 26 Feb 2020 11:41:30 GMT

In this particular case it is working because the numerator of your expression is still not ignoring selection which is why having Only with set analysis makes no difference, but if for some reason you wanted your chart to ignore selection in Quarter, Month, Year field... and your expression was this

Sum({<Quarter, Month, Year>}Sales)/$(vSales)

then you would have needed

Only({<Quarter, Month, Year>} Aggr(NODISTINCT Sum({<Quarter, Month, Year>} Sales), Year))

But because your Numerator is just Sum(Sales), it doesn't matter if Denominator ignores selection in Quarter, Month, Year or not... I would use what @tresB has provided in this case.

Re: Find the Quarter wise % values

Lakshman_1031 — Thu, 27 Feb 2020 07:10:43 GMT

Hi Sunny,

Thanks for your Support.

I achieved my Scenario using this example.

Thanks & Regards,

Lakshman