Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ts3st1000
Contributor
Contributor

Chart on select data

Hi, I am trying to plot a chart on a limited data. Here is an example. in the database, i have a table that looks like:

countryproductsales
Japantype110
Chinatype211
Malaysiatype312
Vietnamtype413
Indonesiatype114
Thailandtype215

I would like to plot Sales by country where product is different from type 2 and type 3, meaning i would like to limit the chart to this table

  

countryproductsales
Japantype110
Vietnamtype413
Indonesiatype114
Thailandtype215

Could you please suggest an expression to do this. thanks very much.

1 Reply
supriyabiware
Creator
Creator

Set Analysis Expression -

=Sum({$<[Product]-={'type2','type3'}>} Sales)

Normal Expression

=If(Not wildmatch(Product ,'type2','type3'), Sum(Sales))


Supriya