Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Sorting a bar chart with a new expression - any ideas?

Hi, hope someone can help

I am trying to create a bar chart with one dimension and one expression and a 2nd expression to sort the bar chat:

Dimension:

=if(Company='1', Applications)

Expression:

Avg(AppScore)

I am trying to sort the results based on a 2nd expression using the sort by expression in the sort tab:

=count({$<Class = {Promoter}>} Class)/count({$<Class = {'Detractor','Passive','Promoter'}>}Class)

This works perfectly in a straight table using 2 normal expressions but when I try in a chart it just doesn't sort correctly.  Any ideas would be much appreciated.

1 Solution

Accepted Solutions
Not applicable

Re: Sorting a bar chart with a new expression - any ideas?

Resolved!

Dimension:  Applications

Expression:  Avg(AppScore)

Sort Expression: =count({<Class = {Promoter}, company={1}>} Class)/ count({<Class = {'Detractor','Passive','Promoter'}, company={1}>} Class)

1 Reply
Not applicable

Re: Sorting a bar chart with a new expression - any ideas?

Resolved!

Dimension:  Applications

Expression:  Avg(AppScore)

Sort Expression: =count({<Class = {Promoter}, company={1}>} Class)/ count({<Class = {'Detractor','Passive','Promoter'}, company={1}>} Class)

Community Browser