Is it possible to combine two combo charts as one?

[#1]

Hi,

I have two combo chart items.

Chart A:

Dimension: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,Dateinsert)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

ChartB:

Dimension: =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

so, the chart A shows Dates on horizotal axis and count of IDs on vertical axis. Chart B shows weeks on horizotal axis and count of IDs on vertical axis.

Now I need to combine the two charts so that the horizontal axis need to show both Weeks and Dates. I,e from 03/02/2014 to 07/02/2014 it should show with week 32.

Is this possible please can anyone let me know.

Thanks.

[#2]

Please find attached.

Edit: I need to show whihc is in attached Need to show.png

[MK_QSL]

You can create a cyclic group for your both dimensions and use in a dimension.

[#4]

Thanks for your prompt reply, and I used cyclic group. But my user need to click on every time right to see week and Dateinsert. I want to have both in horizontal axis. with out my user clicking one by one. Is it possible please let me know.

[MK_QSL · Accepted solution]

Crate a Bar Char with

Dimension1:      =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,Dateinsert)

Dimension2:      =IF(FiscalWeekSerial>=$(curFiscalWeekSeq)-4,FiscalWeek)

Expression1:  Count(DISTINCT {$<DateType={'EnterDate'},FromGent={'0'},Flag={2}>} ID)

Expression2: 0

Open the properties and go to the Presentation tab. Deselect the Show Legend option

Hope this helps....

Update : Please Promote and Demote your first and second dimensions according to your requirements

SOURCE : QlikView for Developers COOKBOOK by Barry Harmsen.

[#6]

Thanks and it is showing for each week different bar colours. Is there any way to display under(below) 03/02/2014 to 07/02/2014 as 32?

EDIT: as attached

[#7]

Further any change to display under(below) 03/02/2014 to 07/02/2014 as 32?

[MK_QSL]

Didn't understand... Please upload your sample file... or proper screen shot.

[#9]

Sorry. what I mean is, is there any other chance with out doing promote or demoting the dimensions?

[MK_QSL]

You can take Week as first dimension and Date as Second...