Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

hamishimrie
Contributor

Using Agg & rank across a time series (time on dimension axis of a chart)

Hi,

I am building a chart with a rank for each month in the year.

My Dimension is a simple "Month Name".

The below is my expression.

 

=

aggr(rank(sum({<ClientName=}>} Sales))

I want to expand my expression to make my chart run across all the months. However if I amend this expression to produce that result, the expression produces the wrong result..

  

aggr(rank(sum({<ClientName=, MonthName=}>} Sales))

Any ideas how I can make this expression evaluate this for each month?

Tags (1)
1 Reply

Re: Using Agg & rank across a time series (time on dimension axis of a chart)

Hi

Try like this

aggr(rank(sum({<ClientName=}>} Sales)),MonthName)

Hope it helps


Community Browser