topic Re: How to remove the X Axis year = 0 ? in QlikView

How to remove the X Axis year = 0 ?

paulyeo11 — Fri, 14 Apr 2017 01:09:06 GMT

Hi All

I have a chart which work fine for last 8 year.

I have make some change of the expression. Now it display when year is missing value.

I need the chart on the right side , the bar is having missing value , i need to remove it.

Hope some one can advise me.

Paul

Re: How to remove the X Axis year = 0 ?

paulyeo11 — Fri, 14 Apr 2017 01:09:58 GMT

my QVW

Re: How to remove the X Axis year = 0 ?

Anil_Babu_Samineni — Fri, 14 Apr 2017 01:30:33 GMT

Just go to dimension and check Suppress When value is null - This will happen after 11.2 SR5 versions.

Re: How to remove the X Axis year = 0 ?

paulyeo11 — Fri, 14 Apr 2017 02:02:16 GMT

Hi Anil

I have try but it does not work.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: How to remove the X Axis year = 0 ?

Anil_Babu_Samineni — Fri, 14 Apr 2017 02:03:52 GMT

Is this you are expecting?

Re: How to remove the X Axis year = 0 ?

paulyeo11 — Fri, 14 Apr 2017 02:07:40 GMT

Yes , this is what is expected. Can you tell me how to do it ?

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: How to remove the X Axis year = 0 ?

Anil_Babu_Samineni — Fri, 14 Apr 2017 02:10:47 GMT

Nothing done, Same Check attached if it helps you. I worked here

Re: How to remove the X Axis year = 0 ?

paulyeo11 — Fri, 14 Apr 2017 02:14:52 GMT

Hi Anil

Okay I am sorry , I have see but my mind thou the 2 tick below did that , my mistake.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: How to remove the X Axis year = 0 ?

Anil_Babu_Samineni — Fri, 14 Apr 2017 02:16:27 GMT

No need to say Sorry sir, Good to hear. Close this thread if you satisfy the answer