Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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...
Hi David,
try this.
Good luck,
Sandro
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
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.
Hi David,
this is the version for QlikSense.
Good luck,
Sandro
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
HI David,
Did you make use of the alternate dimensions property to achieve this?
Thanks,
Sangram.
No, no need of alternate dimensions. If you download the .qvw or the .qvf you can see it.