Discussion board where members can get started with Qlik Sense.
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:
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
Could you please suggest an expression to do this. thanks very much.
Set Analysis Expression -
=If(Not wildmatch(Product ,'type2','type3'), Sum(Sales))