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.
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...
You don't, because a QVW file is made for QlikView. My guess is that Sandro 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.