Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
diana_
New Contributor II

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
Partner
Partner

Re: date(date#()) function

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

2 Replies
Partner
Partner

Re: date(date#()) function

In your X-axis chart properties, try to disable the continuous axis. (Disable auto handling and uncheck "use continuous axis")
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

diana_
New Contributor II

Re: date(date#()) function

Thanks a lot. It worked!