Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
AsmJuv2004
Contributor III
Contributor III

Creating a histogram with a bell curve and vertical reference line

Hi Everyone, 

I have a requirement where I need to show distribution in a histogram along with the bell curve. Another additional requirement is I also need to show vertical trend lines. I wanted to understand if this is possible in Qlik Sense. For better understanding, I have created a dummy look in excel.

AsmJuv2004_0-1710432744929.png

 

Any help would be appreciated.

Labels (4)
4 Replies
Nicolae_Alecu
Creator
Creator

Hello,

Histogram object does not support this, but you can try to do an workaround with combo chart.

Check this video: https://www.youtube.com/watch?v=q2QHhtvzbDc 

AsmJuv2004
Contributor III
Contributor III
Author

Hi @Nicolae_Alecu , thanks for the help. I had seen this video. Just wanted to understand if the vertical reference line is also possible with combo chart?

Nicolae_Alecu
Creator
Creator

Hello,

Yes, it's possible.

Add-Ons > Dimension reference lines -> Add Reference Line

Nicolae_Alecu_0-1710492178165.png

 

AsmJuv2004
Contributor III
Contributor III
Author

Thanks @Nicolae_Alecu  for the help. I was able to get the below chart. Only one problem remains, one of the reference lines is going out of the plot area. 

AsmJuv2004_0-1710762530196.png

 

Now I understood, that for measure reference lines, you can solve this by adjusting the max/min values in the axis. But how do I solve this for dimension reference lines?