Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

1 Solution

Accepted Solutions
maxgro
MVP
MVP

maybe for prev year

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

View solution in original post

5 Replies
Not applicable
Author

Ranjit,

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

Hope it helps!

Regards

Jonathan-

maxgro
MVP
MVP

maybe for prev year

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

Not applicable
Author

thanks Jonathan for the quick reply.

Not applicable
Author

It worked thanks buddy..

jcampbell
Partner - Creator
Partner - Creator