topic Re: Separate Chart for different Region in QlikView

Separate Chart for different Region

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am having two Regions (Us & Canada). I want to have two separate chart for each reason showing respective data at same time.

Currently When I am adding If condition to the dimension it restricting the chart display until I select one of the region in the list box.

My data chart is displaying Monthly sales for 3 key products (so there are three trend line).

So the purpose it to view monthly sales for each region side by side on two Separate chart.

Hope someone can help me with this.

Thanks,

Re: Separate Chart for different Region

vishsaggi — Fri, 31 Aug 2018 15:44:18 GMT

May be try this in your calculated dimension like below and supress when value is null for that dimension.

= Aggr(Only({< Region = {[Canada]} >}Region), Region)

= Aggr(Only({1< Region = {'Canada'} >}Region), Region)

Re: Separate Chart for different Region

trdandamudi — Fri, 31 Aug 2018 15:46:08 GMT

See if the below helps:

Re: Separate Chart for different Region

Anonymous — Fri, 31 Aug 2018 18:51:42 GMT

Thank you Thripumala, It did work for me.

Now if I also have division "East & West" for both country and want to have 4 charts. Is that possible.

I have Modified load according, to the file you attached earlier.

Re: Separate Chart for different Region

trdandamudi — Fri, 31 Aug 2018 22:51:37 GMT

See the attached file and hope this helps:

Re: Separate Chart for different Region

Anonymous — Sat, 01 Sep 2018 00:32:53 GMT

No actually I mean 4 different chart with following.

1. US-West

2. US-East

3. Canada-West

4. Canada-East

I am sorry if I was not clear last time.

Re: Separate Chart for different Region

trdandamudi — Sat, 01 Sep 2018 01:08:25 GMT

No issues and please see the attached. If you think your issue has been resolved then please closed the thread by marking correct answer, So that it will be useful for others also.

Re: Separate Chart for different Region

Anonymous — Sat, 01 Sep 2018 15:24:39 GMT

Perfect. thank you.

Re: Separate Chart for different Region

trdandamudi — Sat, 01 Sep 2018 18:08:35 GMT

You are welcome,,,