topic Re: Restriction dimension values in chart in QlikView

Restriction dimension values in chart

Mon, 26 Oct 2015 18:01:39 GMT

I have to create a chart with country dimension and sum(net sales) as expression.

I have more than 10 countries in my country column .

But in the chart i want to show sales of only three countries ie US, UK and Japan . How do i restrict my dimension values in the column?.

swuehl — Mon, 26 Oct 2015 18:14:14 GMT

=Sum({<country = {'US','UK','Japan'}>} [net sales])

Mon, 26 Oct 2015 19:15:56 GMT

or you can try with this example:

=Sum({<country = {"US", "UK", "Japan"}>} [net sales])

Regards!

MarcoWedel — Mon, 26 Oct 2015 23:53:47 GMT

Hi,

another one:

=Sum({$<country={"(US|UK|Japan)"}>} [net sales])

hope this helps

regards

Marco

Saravanan_Desingh — Sat, 23 Apr 2016 02:25:20 GMT

New learning for me marcowedel‌

So, compound search can be used in Set Analysis