3 graphs in one bar graph

[#1]

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

[#2]

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

Eva

[robert_mika]

You can look at this extension

http://branch.qlik.com/projects/showthread.php?389-D3-Visualization-Library

One of his chart is the option you need

[#4]

HI robert,

Thanks for the reply.

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])

[JonnyPoole]

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.

[#6]

Hi Jonathan,

Thanks for the reply.

Could you please help me with my sample data.

I am not getting. If possible both the scenario.

The problem is my dimension will become the measure.

For Ex: Below expression will give the count of sign ups.

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

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

Thanks,

Pramod

[#7]

Anyone help on this.