topic Re: Requirement on dates in QlikView

Requirement on dates

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Requirement on dates

sunny_talwar — Wed, 11 May 2016 18:20:00 GMT

Can you try this as your dimension:

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

Re: Requirement on dates

Wed, 11 May 2016 18:23:43 GMT

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

Re: Requirement on dates

sunny_talwar — Wed, 11 May 2016 18:27:13 GMT

Can you show your dimension expression?

Re: Requirement on dates

Wed, 11 May 2016 18:27:27 GMT

hi my expression is like this

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

and also i am implementing gannt chart

Re: Requirement on dates

sunny_talwar — Wed, 11 May 2016 18:28:48 GMT

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

Re: Requirement on dates

Wed, 11 May 2016 18:31:58 GMT

dimension is stag number 5225

Re: Requirement on dates

Thu, 12 May 2016 11:20:05 GMT

Hi,

Try using this,

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

Regards,

Snehal Nabar

Re: Requirement on dates

PrashantSangle — Thu, 12 May 2016 11:24:24 GMT

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