Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How do I create a bar chart with 1 measure and multiple dimensions?

I have an attendance spreadsheet with 4 columns Name, 2012, 2013, 2014. My rows consist of the name of attendant and "Y" or "N" under the years. How do you create a bar chart that has attendance as a measure (x-axis) and count of attendees (y-axis). I would like to have 3 bars representing attendance for 2012, 2013, 2014 with one measure. Thanks for you help.

9 Replies
Not applicable
Author

David, my impression of you data look like below:

Name, 2012, 2013, 2014

A, Y, N, N

B, Y, Y, Y

C, N, Y, Y

D, Y, N, Y

There are couple of methods:

1. Create a bar chart with out dimension. You need 3 expressions.

Count({<[2012]={"Y"}>}Name)

Count({<[2013]={"Y"}>}Name)

Count({<[2014]={"Y"}>}Name)

2. While loading the data, using Cross Table function and transpose the data. check below document.

Loading Cross Tables

Not applicable
Author

Let me start of by saying I am new to Qlik....

I user the cross table function and my actual table looks like this...

User_Id        Enrolled                             YorN

1                   enrolled2011                        N

1                   enrolled2014                        Y

1                   enrolled2015                        Y

2                   enrolled2011                        Y

2                   enrolled2014                        Y

2                   enrolled2015                        Y

3                   enrolled 2011                       Y

3                   enrolled 2014                       N

3                   enrolled 2015                       N

I chose Enrolled as dimension and created a custom function for my measure as follows:

Count(If(Enrolled = 'Enrolled 2011',user_id,0))

The bar chart displayed 3 bars all the same size for 2011 2014 and 2015, when I used that function.

I want to be able to have bar chart display the users enrolled for 2011, 2014, 2015 on separate bars, those not enrolled for 2011, 2014 and 2015 or any combination of those.

Please let me know what functions and example of syntax I can use to accomplish this...

Thanks for your help...

hitman1967
Contributor
Contributor

Hi David,

try this.

Good luck,

Sandro

Not applicable
Author

I have been using Qlik for less than a week.

How do you open a .qvw file?  I am using QlikSense Hub and Qlik Management.

Thank you very much for you help.

David

oknotsen
Master III
Master III

You don't, because a QVW file is made for QlikView. My guess is that hitman1967‌ misread your post and thought it was about QlikView.

You can drag-and-drop a QVW into Qlik Sense, but it will loose all visuals and that is the one thing you actually need, so don't bother with that.

May you live in interesting times!
hitman1967
Contributor
Contributor

Hi David,

this is the version for QlikSense.

Good luck,

Sandro

Not applicable
Author

Where are the logs located on Qlik Sense Hub?

I tried importing the file Attendance.qvf  using QMC and got the following error ...

"Failed to import app. Please check the log file"

Thank you very much for your continued help...

David

reddy-s
Master II
Master II

HI David,

Did you make use of the alternate dimensions property to achieve this?

Thanks,

Sangram.

hitman1967
Contributor
Contributor

No, no need of alternate dimensions. If you download the .qvw or the .qvf you can see it.