Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: problem

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
Highlighted
Not applicable

Re: problem

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

Highlighted
Specialist
Specialist

Re: problem

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

Highlighted
MVP
MVP

Re: problem

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

Not applicable

Re: Re: problem

hi tresesco

pfa

Highlighted
Creator III
Creator III

Re: problem

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 .

Highlighted
MVP
MVP

Re: problem

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