topic Re: Stacked Chart by country in % in QlikView

Stacked Chart by country in %

Anonymous — Mon, 19 Dec 2011 16:10:14 GMT

Hi everyone,

Help me to build a chart for the last month.

I have variables country which includes many countries, MYear and context variable which show in percentage.

I need to show in chart Global (all countries) and by each country.

I think it's not possible to show in QV in one chart. I have QV 11.

Thanks,

Stacked Chart by country in %

swuehl — Mon, 19 Dec 2011 16:27:07 GMT

Not sure if there is a special new fetaure with QV11, but I think you could do it like described e.g. here:

http://community.qlik.com/message/92253

Stacked Chart by country in %

Anonymous — Mon, 19 Dec 2011 16:34:32 GMT

Hi Stefan,

I created a new variable which includes only selected countries.I build them one by one in different charts. But I think I miss something that not allow to build them in one chart.

Thanks,

Stacked Chart by country in %

swuehl — Mon, 19 Dec 2011 16:37:46 GMT

I'm not sure if I understand. How do you build your new variable from the different charts?

Re: Stacked Chart by country in %

Anonymous — Mon, 19 Dec 2011 17:01:34 GMT

Please find my attached file.

Regards,

Re: Stacked Chart by country in %

Anonymous — Mon, 19 Dec 2011 19:09:07 GMT

Hi ther,

Who knows how can I add TOTAL?

I have expression in script

If(Value='A','A',If(Value='B','B',If(Value='C','C',If(Value='D','D',If(Value='E','E')))))as Value1

I need to add TOTAL in Value1.( A,B,C,D,E)

Thanks,

Re: Stacked Chart by country in %

swuehl — Tue, 20 Dec 2011 00:17:29 GMT

I just applied above linked solution to your data, please have a look at attached.

I then used the CountryGroup as dimension in a new bar chart, on second sheet. I am not sure what you want to do with the calculation, it seems that you are using some fields in the set expression that don't exist (in this sample). So I just removed the limitation on Country field.

I would suggest that you use a Country field value like 'Others', not NULL() for Countries that don't match your three classes. And if you don't want these multiple if() statements, you could use a pick/ match combination, maybe like:

pick( match([qID_6317_In which of the following countries do you reside?],'Canada','United States', 'United Kingdom', 'Germany')+1, 'Others','US/Canada','US/Canada','UK','Germany')) as Country,

or use a mapping table (please refer to the HELP, search for MAPPING load prefix and applymap() function.

Hope this helps,

Stefan

Re: Stacked Chart by country in %

Anonymous — Wed, 21 Dec 2011 14:49:28 GMT

Hi Stefan,

I played with your syntax. I tried also to found out myself something. I tried to reload in another table and combine them. But without results. I attached my report. I hope it helps to understand what I need .

In my case I think usual stuff doesn't work. I need to use trick or magic.

Thank you for your help,

Re: Stacked Chart by country in %

swuehl — Wed, 21 Dec 2011 15:43:32 GMT

I haven't seen in your sample that you used a code similar to what I posted and reference above, so I am not sure if we are looking for the same. I tried to adapt your code to what I think you are after, find attached.

Re: Stacked Chart by country in %

Anonymous — Wed, 21 Dec 2011 16:34:28 GMT

I need to add variable Global(US, Canada, UK, Germany , Australia, India, ...) in my Country and keep US/Canada, Germany, UK.

Because I use Country as Dimension. Maybe is wrong way? Maybe I need to use aggr or sum of country.

But I don't know how it works and it will hepl me in my request.

Thank you

Re: Stacked Chart by country in %

swuehl — Wed, 21 Dec 2011 16:39:30 GMT

Hm, I think this is exactely what I added in above attached sample, except that the field is called CountryGroup...

So just use different field names?

Have you had a chance to look at my example?

Re: Stacked Chart by country in %

Anonymous — Wed, 21 Dec 2011 17:17:11 GMT

Yes, I checked your report.

I'm not going to use list box to choose Country. It should be TOTAL for all countries and US/Cnada, UK, Germany.

I know how I can use 2 charts for this. 1- for TOTAL and the 2- for US/Cnada, UK, Germany.

Is it possible conmbine them together?

Re: Stacked Chart by country in %

Anonymous — Wed, 21 Dec 2011 19:23:46 GMT

In Dimension Limits Tab check Show TOTAL.

It shows TOTAL.