Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

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

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

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
New Contributor

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

Hi David,

try this.

Good luck,

Sandro

Not applicable

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

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
Honored Contributor III

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

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
New Contributor

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

Hi David,

this is the version for QlikSense.

Good luck,

Sandro

Not applicable

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

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

reddys310
Honored Contributor II

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

HI David,

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

Thanks,

Sangram.

hitman1967
New Contributor

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

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

Community Browser