6 Replies Latest reply: Nov 1, 2015 11:15 PM by Kumar Pramod

# 3 graphs in one bar graph

Hi all,

I have 3 different bar charts like in image below i need to show up in single chart.

How can i do this.

For reference i am attaching the .qvf file. In that it has only single bar and two bar charts, As it is sample data i don't have other two bars and one more chart.

Regards,

Pramod

• ###### Re: 3 graphs in one bar graph

A single graph but with set analysis defining the time frame should works.

Eva

• ###### Re: 3 graphs in one bar graph

You can look at this extension

One of his chart is the option you need

• ###### Re: 3 graphs in one bar graph

HI robert,

Is it possibe to add following measure as dimension?

Sum({\$<CanonicalDate = {">=\$(=max(date(CanonicalDate)-7))<=\$(=max(date(CanonicalDate)))"},client_id = {15}>}[course_completed])

/

Count({\$<CanonicalDate = {">=\$(=max(date(CanonicalDate)-7))<=\$(=max(date(CanonicalDate)))"},client_id = {15}>}[invitation_id])

• ###### Re: 3 graphs in one bar graph

You can dimensionalize most measure expressions by using the aggr() function

Aggr(  <YourMeasureExpression> ,  Dimension1, Dimension2, etc...)

...where Dimension1 etc... determines the level of aggregation which you need to be explicit about.

Also - there is probably a data model solution to this question as well. You can create a resident load to create a new table that leverages qlik's row level association to buckets dates into the 1 or more of the 3 date ranges. Then there is less calculation in the UI. Could be an option if you run into slowness in chart rendering.

• ###### Re: 3 graphs in one bar graph

Hi Jonathan,

I am not getting. If possible both the scenario.

The problem is my dimension will become the measure.

This i need to use to display last 7days, week prior, and program To-date.

Count({\$<DateType = {signed}>}user_signed).

Thanks,

Pramod

• ###### Re: 3 graphs in one bar graph

Anyone help on this.