Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create one bell curve chart.
Can you please help me this. Almost done i mess something.
I followed the Henric Cronström. Please help me guys.
The graph indicates
X-Axis --> Score
Y-Axis --> is Avg(Score) for bell curve
I want to show only Y-Axis with Auto generated like 0-100 values.
Please help me..
Can you please have a look of my excel
In that, 2014 Data sheet i have original data. After that i created one pivot table for without Exclude values.
In this 2014 Data - Please see the name column, In that - I excluded two values
1) Key Message Delivery
2) Sales Objective Category
After that i copied that data, And then i created Main and Standard Demonstration.
Then i create the Normal Distribution which is our Line expression in Qlik.
Make sure, This whole i did in Excel only.
But, qlik i don;t know how to do that. Here, I want to show
1) X-Axis is score which come under the values of 100.
2) Y-Axis might be random with the suitable of Random values ( I mean Normal Distribution)
3) Measure is --> Average (Score, Normal Distribution)
Here, user want to use only Score, rep & name fields only.
I hope you can understand my issue, I apologize my English.
- Anil
Aah, I see.
I don't think you want a histogram at all... I suspect you want this:
What I have done is the following:
HIC
Henric,
Almost i reach the target.
Sorry for troubling, That is my miss understanding. Any way, I excludes two values. But, My max score is 100 only not that i have score with 80 only. After excluding those two fields might be X-axis should be Up to 100 / 80 only.
Avg({$<[2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} AvgRepYearScore)
I use this scenario.
Updated : Did you get a chance to look this. I mean how to exclude those two values from this graph
Help me please