Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date showing through X axis

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

14 Replies
Anonymous
Not applicable
Author

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

Create another for Month

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

hope this helps, upload sample app

Not applicable
Author

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

Anonymous
Not applicable
Author

No Problem create a Calculated dimension as


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

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

amit_saini
Master III
Master III

Hi,

See the attachment.

Thanks,

AS

Not applicable
Author

Bhagirath it's not working.

Not applicable
Author

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

buzzy996
Master II
Master II

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.

Anonymous
Not applicable
Author

can you share sample app

Not applicable
Author

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.