Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Combo chart in qliksense

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
Contributor III

Re: Combo chart in qliksense

Hi Akanksha,

  

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

Thanks,

Not applicable

Re: Combo chart in qliksense

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