Need Help

[qv_testing]

HI Community,

I am facing issue with Stacked Gantt Chart..

I have three dates like

  StartDate        EndDate      PostDate

15-Jul-2015	01-Jun-2016	01-Feb-2017
	01-Jun-2016	01-Feb-2018
14-Dec-2015	01-Jun-2016	01-Feb-2018

I have 2 Expressions, one is Max(EndDate)-Min(StartDate)

1st Expression showing Correct------>  if i have any null value in StartDate i have to show Symbol,  its working..

If i am click Symbol, it showing another format... i have to show only years..

and another one is  Max(PostDate)-Min(EndDate)

2nd Expression not working, it should show bar..

PFA,

Thanks in Advance...

[qv_testing]

Hi Experts,

Anyone can help me...

[#3]

Hi,

Your 2nd expression is working > Max(PostDate)-Min(EndDate)

It become Stacked bar due to more than one expression under combo chart.

If you mean to say on selection of Cross symbol you can only able to see ,

Max(PostDate)-Min(EndDate) Expression evaluated not Max(EndDate)-Min(StartDate) ... Is it the case ?

[qv_testing]

Yes...

if i am use bar chart it showing proper, but i have to symbol also..

then how to show??

is there any other solution????

[#5]

Hi,

PFA,

Please check if it will match with your case or not.

Thanks

[qv_testing]

Hi Harshal,

Thanks for Response...

If i have StartDate Null value, i want to show Symbol instead of bar.

Example:

StartDate     EndDate      PostDate

                 01/07/2016     01/02/2018

Now StartDate Null and EndDate  01/07/2016

01/07/2016   -    Null    =   01/07/2016

If i have Null value in StartDate, I don't want to show bar.... I want to show Symble on Particular  EndDate .

See this

[tripatirao]

Hi

I have gone through your application but i am unable to understand how

Max(EndDate)-min(StartDate)=1900 is coming.

regards

Tripati

[#8]

HI

PFA,

THANKS,

HARSHAL

[qv_testing]

Hi Harshal,

Here one problem, data not coming proper...

[#10]

Hi,

PFA