Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo chart in qliksense


For example

I want to create a combo chart which shows trends of top 10 customers from customer dimension. I have to put filter on customer dimension for  year=2016,  sales > 1M$ and then I want to compare their sales with last year.

The new dimension I created for customer with year and sales filter is showing invalid on chart.

Can anyone please suggest right way to do this.


3 Replies

Hi Akanksha, maybe using this dimension:

=Aggr(only({<year={2016}, customer={"=Sum(sales)>1e6"}>} customer), customer)

Note that the field names are case sentitive, so 'year' is not the same as 'Year', use the field name exactly as they are loaded.

And if you don't want to fix a year and keep the max of the possible years:

=Aggr(only({<year={$(=max(year))}, customer={"=Sum(sales)>1e6"}>} customer), customer)

Creator III
Creator III

Hi Akanksha,


             Please post any example qvf file. will help us to find the output.


Not applicable

Above things worked for my combo chart. Thank you so much Ruben!