topic Re: How can I show multiple bar charts as a single stacked chart? in QlikView

How can I show multiple bar charts as a single stacked chart?

Fri, 08 Mar 2013 14:04:16 GMT

Hi there,

I have some data that I'm trying to display in a single bar chart instead of several separate ones. Really hoping someone can help

My data looks like this:

Country	Internet	Text	Email	Video
UK	1	1	1	5
USA	2	2	2	4
India	3	3	1	1
UK	2	3	1	2
UK	6	4	3	3

The numbers in the columns Internet, Text, Email and Video represent the frequency that people use these media types.

I would like to display the results of this table in a stacked chart as follows:

Would also like to create a list box that allows me to filter by country.

Any help to acheive this would be much appreciated!

Many thanks,

Katie

Fri, 08 Mar 2013 16:14:30 GMT

Hi Katie

Please find the attachment. Hope this gives you an idea. This is just rough, You can enhance on your requiremen,t

Fri, 08 Mar 2013 16:47:13 GMT

Is this what you are looking for?

---------------------------------------------------------------------------------------------

OrgTable:

LOAD

INLINE [
Country, Internet, Text, Email, Video
UK, 1, 1, 1, 5
USA,2, 2, 2, 4
India, 3, 3, 1, 1
UK, 2, 3, 1, 2
UK, 6, 4, 3, 3
]

;

NewTable:

CrossTable (Type,Value , 1)
LOAD *

RESIDENT OrgTable;

DROP TABLE OrgTable;

----------------------------------------------------------------------------------------------------------

Create calculated dimension containing a set of if then statements for the groupings.

if(Value = 1, 'Every Day',
if(Value = 2, 'Every Week',
if(Value = 3, 'Every Month',
if(Value = 4, 'Every Year',
if(Value = 5, 'Rarely',
if(Value

= 6, 'Never')
)
)
)
)
)

Mon, 11 Mar 2013 12:23:44 GMT

Thanks so much for this - it works perfectly!

Mon, 11 Mar 2013 12:25:24 GMT

Thank you dibblemc - I used KStreak S's answer first and it worked really well, although I did find your reply really helpful