Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Highlighted
diana_
New Contributor

date(date#()) function

Hi,

In my dataset I have column Period with dates 01/01/2018, 01/02/2018 in a format of Jan-18, Feb-18 etc. and another column with numeric months (1, 2,...12).

When I prepare a combo chart I would like to have month abbreviations (Jan-2018, Feb-2018, etc) on x-axis, however I can only get desired visualization with numeric month values, when applying function =date(Period,'MMM-YYYY'), the chart looks  not the way I wish (stacked columns look like lines),the formula for date does not give intended result (MMM-YYY) (picture 2). I have no problem with the same date function in other charts though. Could you please advise the solution? 

1..PNGPicture 12..PNGPicture 2

1 Solution

Accepted Solutions
Vegar
Valued Contributor II

Re: date(date#()) function

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")
Please ekskuse my Norglish and Swenglish typos.
2 Replies
Vegar
Valued Contributor II

Re: date(date#()) function

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")
Please ekskuse my Norglish and Swenglish typos.
diana_
New Contributor

Re: date(date#()) function

Thanks a lot. It worked!