Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

Data

My data looks like this:

CountryInternetTextEmailVideo
UK1115
USA2224
India3311
UK2312
UK6433

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

  • 1 = every day
  • 2 = every week
  • 3 = every month
  • 4 = every year
  • 5 = rarely
  • 6 = never

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

chart3.jpg

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


1 Solution

Accepted Solutions
Not applicable
Author

Hi Katie

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

View solution in original post

4 Replies
Not applicable
Author

Hi Katie

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

Not applicable
Author

Is this what you are looking for?

Stack Chart Type.PNG

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

 

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')
)
)
)
)
)

Not applicable
Author

Thanks so much for this - it works perfectly! 

Not applicable
Author

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