Sales By Country

[tracycrown]

Dear Sir/Madam

I try to present Products by Country but not sure all Products appear in each country, can someone kindly help to solve my problem ?..

The correct answer should be Country A and B only show products with Prefix T and B respectively.

Thank you

Tracy

[tracycrown]

Dear John

Thank you so much for your kind effort and advices.

I totally agree that it is impossible to exclude those unwanted products in Trellis chart. I also find it difficult to follow your advice as it is too advance for me to understand such as concatenating country ........

Anyway thank you again

Tracy

[tracycrown]

Dear Jyothish

All the time, I am using Trellis chart but unable to exclude unwanted Products by Country.

Regards

Tracy

[jyothish8807]

Hi Tracy,

In that case you try creating a separate data set excluding those product and use  the new data set for building trellis charts . Just a thought, it might increse the app size if you are dealing with huge data.

Something like this:

A:

Load

Product,

Country

from <>

B:

Load

Product as NewProduct

Country

resident A

where Product <> 'ABC';

Then use New product in the charts.

Br,

KC

[tracycrown]

Dear Jyothish KC

This is not what I want as I will have to write many scripts for all products.

Regard

Tracy 

[qlikviewwizard]

Your requirement is not possible.