Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Combine 2 bell graphs into 1

Hi, I am trying to compare 2 normalised distribution graphs for 2 different years (2015 and 2016). Currently, I have to create 2 seperate graphs for each year, however i would like them to be in 1 graph only. How do I combine both graphs together into one?

Currently I am coding it as:

Dimension : =Round(GBP, BinWidth)

1st expression : =Count({<YEAR ={"2015"}>}GBP)

2nd expression : =Only({<YEAR={"2015"}>}NORMDIST(Round(GBP, BinWidth),Avg(total GBP),Stdev(total GBP),0)*BinWidth*Count(total GBP))

for the specific year for 2015, and the same code is used for the graph for year 2016.

Is there a way to code such that both graphs are combined into one, so that comparisons between the 2 years can be more visual?

Thank you!

Attached images for the 2 different years.

3 Replies

Re: Combine 2 bell graphs into 1

please post an example qvw.

thanks

regards

Marco

klausskalts
Contributor

Re: Combine 2 bell graphs into 1

....and it's not possible to have all four expressions in the same graph?

galax_allu
Valued Contributor

Re: Combine 2 bell graphs into 1

I agree with  Klaus ...

You can have all your expressions in one CHART..

and then

  1. Edit the chart and add a third expression with just a value of 0:
  2. A new legend will appear.
  3. Open the properties and go to the Presentation tab. Deselect the Show  Legend option:

this will make sure that your two years data will separate with some space

Untitled.jpg

Community Browser