Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Static X axis

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Static X axis

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.


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Static X axis

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.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Not applicable

Re: Static X axis

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

D1

D2

D3

Midfield

Wide

Tackles Missed, TackleMissedZone

2, D1

1, Wide

3, Nearside - D1

1, Nearside - D2

2, Midfield

1, Wide

2, D3

1, Wide

Highlighted
MVP & Luminary
MVP & Luminary

Re: Static X axis

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

D1

D2

D3

Midfield

Wide

];


talk is cheap, supply exceeds demand