topic Re: Date showing through X axis in QlikView

Date showing through X axis

Fri, 03 Apr 2015 07:17:51 GMT

Hi team I have to show my date like below

1 2 3 4 5 6 7 8 9 10 11 12

2015

Where 1,2,3,4,......,12 is the Month and 2015 is Year. My date in YYYYMM format.

Is it possible?

Regards

Anup

Re: Date showing through X axis

Anonymous — Fri, 03 Apr 2015 08:19:07 GMT

create a list box as Year(date#(Datefield,'YYYYMM'))

Create another for Month

num(month((date#(Datefield,'YYYYMM')))

hope this helps, upload sample app

Re: Date showing through X axis

Fri, 03 Apr 2015 08:37:28 GMT

Thanks Bhagirath for your reply, I want use this time dimenssion into a object as a dimenssion.

Re: Date showing through X axis

Anonymous — Fri, 03 Apr 2015 08:40:21 GMT

No Problem create a Calculated dimension as

Year(date#(Datefield,'YYYYMM'))

and another as num(month((date#(Datefield,'YYYYMM')))

Re: Date showing through X axis

amit_saini — Fri, 03 Apr 2015 08:43:45 GMT

Hi,

See the attachment.

Thanks,

Re: Date showing through X axis

Fri, 03 Apr 2015 09:41:09 GMT

Bhagirath it's not working.

Re: Date showing through X axis

Fri, 03 Apr 2015 09:44:14 GMT

Thanks amit. But I want a calculated dimension where Month and Year will be shown like my post. Actually I want to show my charts X axis like ----

1 2 3 4 5 6 7 8 9 10 11 12

2015

Re: Date showing through X axis

buzzy996 — Fri, 03 Apr 2015 09:44:29 GMT

very much possible,

if ur having month & year as 2 dimensions,pls add those 2 dimensions in ur dimension tab & put ur expression expression tab.

tht will show automatically into ur chart accordingly ur needs.

Re: Date showing through X axis

Anonymous — Fri, 03 Apr 2015 10:07:42 GMT

can you share sample app

Re: Date showing through X axis

Fri, 03 Apr 2015 10:47:02 GMT

Actually Shiva, I have to show month wise company sale. So Company is another dimension in my chart if I add Month & Year as a different dimension then it will not work. Thanks for your reply.

Re: Date showing through X axis

Anonymous — Fri, 03 Apr 2015 11:01:04 GMT

Hi Anup,

I have created a Sample application with YYYYMM format date and then displayed are the list boxes as expected

Re: Date showing through X axis

Gabriel — Fri, 03 Apr 2015 11:06:49 GMT

Hi,

If you're not calculating the dimension, then have Year and Month as your dimension.

You can have as expression (i.e Sum(Sales)) and just zero (0) as the second expression.

Go to the presentation tab and deselect Show Legend

Re: Date showing through X axis

Mon, 06 Apr 2015 10:52:57 GMT

Bhagirath thanks for your reply, actually I want to create a chart where I want show my dimenssion like

1 2 3 4 5 6 7 8 9 10 11 12 this manner through the X axis.

2015

Generaly I am able to show the dimenssion like 201501,201502,201503,201504.... like this manner but this is not the rquirement.

Regards

Anup

Re: Date showing through X axis

Anonymous — Mon, 06 Apr 2015 10:59:36 GMT

Hi Anup,

Please find attached

Re: Date showing through X axis

buzzy996 — Mon, 06 Apr 2015 11:12:29 GMT

create year lable thrugh text object and place in ur x-axis,that's only the solution i beleives,if u ned like above.

and use ur yrmth/mth and company and company sales as dim& expressions.