topic Restrict Years in QlikView

Restrict Years

Nagaraju_KCS — Thu, 29 Oct 2015 10:54:49 GMT

Hi All,

I want to restrict years front end (UI)..

i have many years like 2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024

In my chart i have to show only 2015,2016,2017,2018,2019,2020

I have Gantt Chart... this is my expression Max(EndDate) - Min(StartDate)

Thanks in Advance....

Re: Restrict Years

swuehl — Thu, 29 Oct 2015 10:59:45 GMT

Maybe using a set Expression

Max( {<Year = {">=2015<=2020"}>} EndDate) - Min({<Year = {">=2015<=2020"}>} EndDate)

Re: Restrict Years

Nagaraju_KCS — Thu, 29 Oct 2015 11:14:11 GMT

Thanks for Quick response..

I want to show 2012 to 2016 years only..

PFA,

Re: Restrict Years

Kushal_Chawda — Thu, 29 Oct 2015 11:37:00 GMT

Please see the attached

Re: Restrict Years

Thu, 29 Oct 2015 11:44:09 GMT

Hi Qv_Testing

Do you mean to only show cases started in those years on your Gantt chart? If so, one option would be to add a calculated dimension to your chart, to replace years outside your range with nulls, then suppress null. (See the attached, also with a list box showing Year(StartDate) ).

I believe you'd get better performance if you can calculate 'Year(StartDate) AS StartYear' as part of your load script, so you don't have to keep calculating that on the fly.

Does that answer your query?

Re: Restrict Years

Nagaraju_KCS — Thu, 29 Oct 2015 12:05:21 GMT

ThanX Kush...

Re: Restrict Years

Nagaraju_KCS — Fri, 30 Oct 2015 04:46:04 GMT

Hi All,

Thanks EveryOne..

My problem is reference line it should be after 2015 year

My scale also it should be unique years, that's why i have mentioned static step 365 days..

Please anyone can help me?????

Re: Restrict Years

Nagaraju_KCS — Fri, 30 Oct 2015 06:57:49 GMT

HI Kush,

How to set reference line..??

Anyone face reference line issue.. Please help me

Re: Restrict Years

Kushal_Chawda — Fri, 30 Oct 2015 07:07:33 GMT

where you want the reference line?

Re: Restrict Years

Nagaraju_KCS — Fri, 30 Oct 2015 07:22:52 GMT

in chart..

i used in Presentation tab--> reference line

exp today()

but in my chart reference line it showing before 2015 year... i want to show after 2015 (it should be after 2015)