topic Re: Need Help in QlikView

Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 05:16:04 GMT

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

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 05:17:15 GMT

Hi Experts,

Anyone can help me...

Re: Need Help

Fri, 20 Nov 2015 05:38:52 GMT

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 ?

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 05:58:59 GMT

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

Re: Need Help

Fri, 20 Nov 2015 06:48:33 GMT

Hi,

PFA,

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

Thanks

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 07:32:43 GMT

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

Re: Need Help

tripatirao — Fri, 20 Nov 2015 09:46:11 GMT

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

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

regards

Tripati

Re: Need Help

Fri, 20 Nov 2015 10:17:27 GMT

PFA,

THANKS,

HARSHAL

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 10:58:01 GMT

Hi Harshal,

Here one problem, data not coming proper...

Re: Need Help

Fri, 20 Nov 2015 11:36:49 GMT

Hi,

PFA

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 19:30:41 GMT

Hi,

If i am using Invisible option, every bar starting from 2016,

My chart should be like..

because my data start from date 2013 year also....

Re: Need Help

Nagaraju_KCS — Fri, 20 Nov 2015 20:31:58 GMT

HI,

Please anyone can help me????