Combo chart in qliksense

[#1]

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

[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]

Hi Akanksha,

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

Thanks,

[#4]

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