Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

problem

I want to split a large application into small application having data for 2 yrs only .

But the problem is, I want to make it dynamic whenever yrs change, it automatically change

Suppose current yr is 2014 then it display the data of 01-apr-2013 to 30-mar-2014

in next yr it should display data of 01-apr-2014 to 30-mar-2015

how we can do that? how we can change the min date in calender too

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Define your variables in the script rather than in the front end. Script can't refer variables from front-end.

Let var=year(Today());
Let old=year(Today())-1;

LET varMinDate = Num(makedate($(old),1,1));

View solution in original post

6 Replies
Not applicable
Author

i have created a variable old= year(today())-1............i.e previous year

and variable var =year(today())...........current  year

In Calender i wrote

LET varMinDate = Num(makedate($(old),1,1));

But it not work

maleksafa
Specialist
Specialist

so you want to split your QVW into multiple QVWs? if that is the case then you need a publisher.

tresesco
MVP
MVP

Seems good to work. Could you share your sample app that demonstrates the issue?

Not applicable
Author

hi tresesco

pfa

vinay_hg
Creator III
Creator III

hi swetha, did you downloaded the qvc.qvs calender control which i have suggetsd in earlier thread.

if yes,  then through set analysis you can do it easily.

or even through variable how u r trying. because the QVC.qvs contorl will give all finacial year calender dates and year dates as u required .

tresesco
MVP
MVP

Define your variables in the script rather than in the front end. Script can't refer variables from front-end.

Let var=year(Today());
Let old=year(Today())-1;

LET varMinDate = Num(makedate($(old),1,1));