topic Re: Restrict the date field in QlikView

Restrict the date field

bhavvibudagam — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a date field i.e ACCIDENT_DATE.In the date field i have the data from 2001 to 2016.

My requirement is when i click on 2006 then it has to be displayed back 5 years i.e from 2001 to 2006.

It has to be done in Dynamically in Script only.Please help me to do.If possible please attach the sample qvw file.

Re: Restrict the date field

bindu_apte — Thu, 09 Jun 2016 07:03:49 GMT

Hi,

Hope this thread will help.

Dynamic Ytd from selection

Re: Restrict the date field

Thu, 09 Jun 2016 07:25:04 GMT

Hi Bhavvi,

try like below

ACCIDENT_DATE=<=$(max(ACCIDENT_DATE))

in your expression.

Regards

Tripati

Re: Restrict the date field

Kushal_Chawda — Thu, 09 Jun 2016 07:28:29 GMT

try below expression

=Sum({<Year = {">=$(=max(Year)-5)<=$(=max(Year))"}, Year=>}Amount)

Re: Restrict the date field

Digvijay_Singh — Thu, 09 Jun 2016 07:49:27 GMT

Check this example, just removed 'Year=' from what Kushal has suggested

Re: Restrict the date field

Digvijay_Singh — Thu, 09 Jun 2016 07:52:09 GMT

Also not sure why you would want this to be done in script, you may need to you asoftable concept along with flag creation to identify 5 years window in the front end.

Re: Restrict the date field

bhavvibudagam — Fri, 10 Jun 2016 17:18:36 GMT

Thank you so much Digvijay for the above attachment file. Can you please upload the Sample Qvw file with flag creation.