set analysis - percentage of a column for prev year and curr year in a chart.

[#1]

help needed for a set analysis expression for calculating the percentage of  for Column 'a'  like ( Sum(a)/Count(a) *100)  shown in the chart for previous year and current year.

[#2]

Ranjit,

You should try to use Year as dimension of the chart.

Hope it helps!

Regards

Jonathan-

[maxgro · Accepted solution]

maybe for prev year

sum( {$<Year = {$(=Max(Year)-1)}>} a ) / count( {$<Year = {$(=Max(Year)-1)}>} a )

[#4]

thanks Jonathan for the quick reply.

[#5]

It worked thanks buddy..

[jcampbell]

You might find this helpful:

Qlik Sense Set Analysis Percentage Calculation