Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing one datapoint for "several selections"?

I had a really difficult time to Google this but consider that I have the following date:

DateGoalsSubcategoryScore
2011-01-01MathTeamwork2
2011-01-01MathLeadership5
2011-01-01MathAnalytics6
2011-01-01EnglishTeamwork12
2011-01-01EnglishLeadership9
2011-01-01EnglishAnalytics14

2011-06-01

MathTeamwork4
2011-06-01MathLeadership3
2011-06-01MathAnalytics6
2011-06-01EnglishTeamwork10
2011-06-01EnglishLeadership7
2011-06-01EnglishTeamwork16




Obviously the real data has much more datapoints but the same amount of fields (four fields), I want to be able to show each individual score based one selection and I do not know how to achieve this.

I thought that I would make a diagram with Date, Goals and Subcategory as dimensions and Score as an expression, however this does not seem to work?What I am doing wrong and how would I be able to achieve this?

16 Replies
Not applicable
Author

I have personal edition so I cannot really see it but I can see the code:

LOAD Date,

          Goals,

          Subcategory,

          Score,

          Goals &'-'& Subcategory as GoalSubs

However, I can not see the structure of your graph, maybe you can take a printscreen of dimensions and expressions? Sorry if I am asking to much

swuehl
MVP
MVP

Sure:

this is my script:

LOAD Date,

     Goals,

     Subcategory,

     Score,

     Goals &'-'& Subcategory as GoalsSubs

FROM

[http://community.qlik.com/thread/35702?tstart=0]

(html, codepage is 1252, embedded labels, table is @1, filters(

Remove(Row, Pos(Top, 14))

));

Then I did just bar chart with

dimensions Date and Goalssubs and Expression Score

It looks like this:

Scores1.png

Scores2.png

Not applicable
Author

Another way to get the same output as shown by sweuhl is to create a calculated dimension of Goals and Subcategories in the chart dimensions.Goals_Subcat.PNG

Not applicable
Author

Thank you very much! I managed to solve it and you been very patient and helpful, big star for you my friend!

anuradhaa
Partner - Creator II
Partner - Creator II

Do you know how to show the some in 1/1/2011 (48) as total and other date in this chart?

Anonymous
Not applicable
Author

Good show stephen.

Can i do this without concatenation?

I want the same scenario like the attached screen.

" Sample_1 is the sample given by client "

" QV_Result is the report that i am getting in QV. "

I very well know i am doing a small mistake but i am not able to fix that.

Can you help me here?

Rgds,

Nandha

Anonymous
Not applicable
Author

Good show stephen.

Can i do this without concatenation?

I want the same scenario like the attached screen.

" Sample_1 is the sample given by client "

" QV_Result is the report that i am getting in QV. "

I very well know i am doing a small mistake but i am not able to fix that.

Can you help me here?

Rgds,

Nandha

Attachments: