Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Requirement on dates

Hi

I have created a bar chart and i selected data on value points but which is giving wrong value like 12/12/1900 instead of 12/09/2014.what is the issue and what is the solution.

Thanks

siddiq

8 Replies
sunny_talwar

Can you try this as your dimension:

Date(Date#(DateField, 'DD/MM/YYYY'))

Not applicable
Author

hi

i am getting like this and i want to show start date and end date on the bar

sunny_talwar

Can you show your dimension expression?

Not applicable
Author

hi my expression is like this

date(Max( [Solution Proposal Finish]))-date(Min([Solution Proposal Start]))

and also i am implementing gannt chart

sunny_talwar

Max-Min gives the number of days. How do you expect to see a date for that?

Not applicable
Author

dimension is stag number 5225

Not applicable
Author

Hi,

Try using this,

Date(Date#([Solution Proposal Finish], 'DD/MM/YYYY'))


Regards,

Snehal Nabar

PrashantSangle

Hi,

check in text object.

> =max([Solution Proposal Finish])

> =min([Solution Proposal Start])

> = max([Solution Proposal Finish])-min([Solution Proposal Start])

> = date(max([Solution Proposal Finish])-min([Solution Proposal Start]))

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂