topic Re: Graph dimension question in QlikView

Graph dimension question

Mon, 27 Jan 2014 14:10:35 GMT

Hi,

I have a couple of line charts with the following dimensions and expressoins.

Chart 1:

Dimension: StartIntervalTime

Expression: COUNT(DataEventID)

Chart 2:

Dimension: EndIntervalTime
Expression: COUNT(DataEventID)

These produce the following two charts:

I however want to show both the graphs on a single chart. Usually I would simply add another expression but here both the charts are running from a different dimension.

How can I get both graphs onto the same chart?

Thanks in advance for your help with this.

Dan

Re: Graph dimension question

Mon, 27 Jan 2014 14:16:33 GMT

Hi,

From a single chart, use the second expression. Go to Axes tab, try to change the second expression possition to Right[top] and check the Split axes and change to value 50%.

Re: Graph dimension question

Anonymous — Mon, 27 Jan 2014 14:19:14 GMT

Daniel,

I think the next approach will work:
Create data island with one field Intervals. Create chart with Intervals as dimension, and the next two expressions:
StartCount = COUNT(if(StartIntervalTime=Intervals, DataEventID))
EndCount = COUNT(if(EndIntervalTime=Intervals, DataEventID))
Warning: the performance maybe be poor with a large amount of data.

Regards,
Michael

Re: Graph dimension question

Mon, 27 Jan 2014 14:20:06 GMT

Hi Dan, In the above case you need to create common IntervelTime (In Link table if required) for both fields and use this new field as the Dimension. Similarly create the FLAG weather its start or end .

Dimension: IntervelTime

Expression1: Count({<FLAG={'START'}>}DataEventID)

Expression2: Count({<FLAG={'END'}>}DataEventID)

Re: Graph dimension question

maxgro — Mon, 27 Jan 2014 14:35:19 GMT

see attachment

Re: Re: Graph dimension question

Anonymous — Mon, 27 Jan 2014 14:51:22 GMT

Here is a version with island (based on Massimo Grossi)