Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ts3st1000
New 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
Contributor

Re: Chart on select data

Set Analysis Expression -

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

Normal Expression

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


Supriya

Community Browser