topic Need help on YTD display!! in QlikView

Need help on YTD display!!

Mon, 12 Sep 2011 15:22:00 GMT

Hi,

I had a requirement to display the previous years LTCR cases alongwith Last Yr and Current year YTD in a single graph. Though I was able to achieve this but problem now is when I make an year selection all the bars still display for all other years whereas I would just like to see the selected year bar to be displayed.

I have attached an example file.

Looking for some immediate help!!

Thanks

Re: Need help on YTD display!!

Mon, 12 Sep 2011 17:15:28 GMT

Try changing the expression to:

=IF(Year=$(vCYear)&' '&'YTD' or Year=$(vLYear)&' '&'YTD',(sum(LOST_TIME_CASE)*200000)/sum(HOURS_WORKED),if (only(Year), (sum({$<Year= , Quarter= ,[Month Name]= >}LOST_TIME_CASE)*200000)/sum({$<Year= , Quarter= ,[Month Name]= >}HOURS_WORKED)))

Regards,

Gordon

Re: Need help on YTD display!!

Tue, 13 Sep 2011 08:09:27 GMT

Thanks a lot Jordon!! You are awesome...