topic Static X axis in QlikView

Static X axis

Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I am looking at creating a static x axis that does not change even when there is no data in that field

I am wanting to display the number of Missed Tackles by Phase on a bar chart (Total 15 Phases)

However, when there are no Missed Tackles in a specific phase, it does get displayed on the x axis. I need Phases 1-15 to be displayed at all times

The dataset, however, does not display that there was no Missed Tackles in the phase (See Below)

Tackles Missed, PhaseNo

2, 1st Phase

1, 2nd Phase

3, 4th Phase

1, 5th Phase

2, 8th Phase

1, 11th Phase

2, 12th Phase

1, 15h Phase

Thanks

Re: Static X axis

Gysbert_Wassenaar — Thu, 03 Mar 2016 17:53:27 GMT

First you need to create the missing phases themselves. Something like this will do that:

Phases:

LOAD * WHERE not match(PhaseNo,'1th Phase','2th Phase');

LOAD RecNo() & 'th Phase' as PhaseNo

AutoGenerate(15)

;

Data:

LOAD * INLINE [

Tackles Missed, PhaseNo

2, 1st Phase

1, 2nd Phase

3, 4th Phase

1, 5th Phase

2, 8th Phase

1, 11th Phase

2, 12th Phase

1, 15th Phase

];

Then in the bar chart go to the Presentation tab of the properties window and uncheck the option Suppress Zero-Values and enable the option Zero on Bars.

Re: Static X axis

Tue, 08 Mar 2016 14:28:52 GMT

Thank you

Worked perfectly

I tried to apply this principle to another equation but could not get it right

Its is the same principle except with different data

(All fields include the following)

I need the data to be displayed on the x axis at all times

Nearside - Wide

Nearside - Midfield

Nearside - D3

Nearside - D2

Nearside - D1

RUCK

Midfield

Wide

Tackles Missed, TackleMissedZone

2, D1

1, Wide

3, Nearside - D1

1, Nearside - D2

2, Midfield

1, Wide

2, D3

1, Wide

Re: Static X axis

Gysbert_Wassenaar — Wed, 09 Mar 2016 06:50:10 GMT

In this case try an outer join:

Data:

LOAD * INLINE [

Tackles Missed, TackleMissedZone

2, D1

1, Wide

3, Nearside - D1

1, Nearside - D2

2, Midfield

1, Wide

2, D3

1, Wide

];

OUTER JOIN (Data)

LOAD * INLINE [

TackleMissedZone

Nearside - Wide

Nearside - Midfield

Nearside - D3

Nearside - D2

Nearside - D1

RUCK

Midfield

Wide

];