Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Showing one datapoint for "several selections"?

Could you maybe reduce the three dimensions to up to two by concatenating e.g. Goals and Subcategories, creating a new dimension?

16 Replies
Not applicable

Showing one datapoint for "several selections"?

Did you do sum(Score) or just Score?

Not applicable

Showing one datapoint for "several selections"?

No, I do not want to sum score... basically if I make a barchart and make the following selection

Date: 2011-01-01

Goals: Math

Subcategory: Teamwork, Leadership & Analytics

I would want this selection to show three different scores (2, 5 and 6 on one bar each)

MVP
MVP

Showing one datapoint for "several selections"?

The resulting table looks fine too me, except that

on 2011-06-01, you have multiple records for English and Temwork with values 10 and 16.

You won't get individual lines for them.

You could add Score to your dimensions too and add an expression

=1

and hide this expression in presentation (talking about a straight table), but this will only work for unique combinations of Score, Date, Goals, Subcategory.

So maybe you could add a record no to the table and hide this in presentation tab of the properties?

Regards,

Stefan

Not applicable

Showing one datapoint for "several selections"?

Yes the last row should be analytics, sloppy copying

So yeah, I find that each line has an unique identified with the combination of Date, Goals and Subcategory... but I still don't manage the data to show this way.

I would make a barchart with date, goals and subcategory as three individual dimensions?

And then add the Score as a expression?

So if I selected all dates (2), all goals (2) and all subcategories (3) I would get 12 datapoints... that's what I am after

MVP
MVP

Showing one datapoint for "several selections"?

I believe the standard behaviour of a bar chart allows 3 dimensions and 1 expression only in stacked style.

So you will probably only get a stacked bar with stacked subcategories, right?

Is that your problem?

Not applicable

Showing one datapoint for "several selections"?

Yeah, that explains it! I changed it to stack bars and it show perfectly, however this is not how I like it... I like it as a histogram (like an inflation rate chart over time?)...

Is that possible and how?

MVP
MVP

Showing one datapoint for "several selections"?

Could you maybe reduce the three dimensions to up to two by concatenating e.g. Goals and Subcategories, creating a new dimension?

Not applicable

Showing one datapoint for "several selections"?

How would I do that the best way? I could combine subcategory and goal as "one selection", ie always requiring a selection of both of those...

MVP
MVP

Re: Showing one datapoint for "several selections"?

Hm, not sure what you mean..

Please have a look at attached (and at the script part for concatenation).

Maybe like this?

Community Browser