I am trying to filter but by creating a dimension from inside the content of table
I have two table Table 1: List of Questions (Skill 1, Skill 2 etc) and Choice of 4 Answers (No Knowledge, Basic, Proficient, Expert)
Table 2: A table of just the 4 Answers (No Knowledge, Basic, Proficient, Expert) for LookUp.
I want to create a simple chart with the Level aon the X-Axis (No Knowledge, Basic, Proficient, Expert) and the count by each Question (Skill 1, 2 etc) . Should be easy to do but I can't get the results despite trying many things including how the table are joined etc.
Re: I am trying to filter but by creating a dimension from inside the content of table
ok great. you probably don't need your second table. you just need to play with the first one. here is the generic step: 1. load your 1st table into qlik sense 2. go to data manager > table 3. click on edit (pencil icon) 4. then, find the unpivot button > click on 2 Columns > click on Apply Unpivoting. 5. Rename your first column as "Type of Skill". Rename your second column as "Skill Level" 5. click load data button 6. Edit your sheet, add in the Bar Chart 7. 1st Dimension = "Skill Level". 2nd Dimension="Type of Skill".Measure = "Count(Type of Skill) 8. Go to the Bar Chart's appearance then change the display to your needs. done 🙂
~ By Candice. Superb experience and enthusiasm on Tableau, Qlik Sense and Power BI. Visit https://datamakery.com for continuous learning program on analytics.