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.

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

Combo chart in qliksense

Hi,

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.

Thanks,
Akanksha

3 Replies
rubenmarin

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)

jayaseelan
Creator III
Creator III

Hi Akanksha,

  

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

Thanks,

Not applicable
Author

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