Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qliksense Chart with date

Hi, 

i need help!

I need to create a chart where the dimention on the X-Asis is Month-Year (jan-2013, feb-2013 ...)

I really don't know how to do this?

any idea?

thanks a lot

F.

17 Replies
robert99
Specialist III
Specialist III

Did this not work

date(monthstart(date(date#(YourDateFieldName, 'YYYYMMDD'), 'YYYY-MM-DD')), 'MM-YYYY')

Not applicable
Author

i'm using a line chart, the dimension are a month-year on X asis and Count ID on the Y axis

robert99
Specialist III
Specialist III

It has split the month?

How many IDs do you have for each mth. 13?

Not applicable
Author

I have 15.000 different IDs only for jan i have 13 IDs.

i  can't understand why now the id's are not more splitted...

robert99
Specialist III
Specialist III

According to this graph you have 13 IDs for every month.

Are you sure this is not correct?

You coudl try

COUNT (ID & Starting Date)

Not applicable
Author

I reloaded the script and now everything is working!

thanks a lot for you help RJ!

best regards

Francesco

robert99
Specialist III
Specialist III

OK Good

Remember to mark answers as helpful or correct

r_wroblewski
Partner - Creator III
Partner - Creator III

Hi

If you change the formula like RJ sent to you it should work.

I tried by myself in a test app & it works fine.

Best regards

Ronny