Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld May 10-12, Online and Free! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Taka4
Contributor II
Contributor II

How to create a bar chart with two dimensions (one with multiple and another with two variables)

I am new to Qlik sense and trying to learn. I am trying to create a bar chart that has two dimensions (one dimension with several variables and another with two variables.)  My dataset and the image of my intended bar chart are shown below. What should I set for the dimensions and measure? Should I revise my dataset?

S__14180355.jpgScreen Shot 2019-03-03 at 3.20.40 PM.png

Labels (2)
2 Solutions

Accepted Solutions
rogerpegler
Creator II
Creator II

I'm assuming each row in your data set represents a single case or scenario and the  bars in the bar chart reflect the number of cases/scenarios.

(Using CrossTable load) Convert the data into a format like:

Case / Goal / Priority
1 / Saving Money / Second
1 / Finding Job / Top
1 / Taking Care of Children / Top
2 / Finding Job / Second
etc

Dimensions : Goal & Priority
Measure: count(Case)

 

View solution in original post

rogerpegler
Creator II
Creator II

For the attached XL, the load script is:

CrossTable(Goal, Priority)
LOAD Case,
[Save Money],
[Finding Job],
Education,
Children
FROM
[H:\Documents\Priorities.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

(I used QlikView which has a wizard to build it for you!)

View solution in original post

4 Replies
rogerpegler
Creator II
Creator II

I'm assuming each row in your data set represents a single case or scenario and the  bars in the bar chart reflect the number of cases/scenarios.

(Using CrossTable load) Convert the data into a format like:

Case / Goal / Priority
1 / Saving Money / Second
1 / Finding Job / Top
1 / Taking Care of Children / Top
2 / Finding Job / Second
etc

Dimensions : Goal & Priority
Measure: count(Case)

 

View solution in original post

Taka4
Contributor II
Contributor II
Author

Thank you so much for your solution. Yes, each row represents answers of each participants. Could you also tell me how to use CrossTable load on Qlik sense? I am confused about how to use "crosstable" syntax to convert the data.... Thanks!
rogerpegler
Creator II
Creator II

For the attached XL, the load script is:

CrossTable(Goal, Priority)
LOAD Case,
[Save Money],
[Finding Job],
Education,
Children
FROM
[H:\Documents\Priorities.xlsx]
(ooxml, embedded labels, table is Sheet1);

 

(I used QlikView which has a wizard to build it for you!)

View solution in original post

Taka4
Contributor II
Contributor II
Author

That worked!!! Thank you so much for your suggestion!