topic Re: problem in QlikView

problem

Wed, 03 Sep 2014 07:36:07 GMT

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

Wed, 03 Sep 2014 08:14:01 GMT

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 — Wed, 03 Sep 2014 08:17:56 GMT

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

tresB — Wed, 03 Sep 2014 08:20:08 GMT

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

Wed, 03 Sep 2014 08:27:05 GMT

hi tresesco

pfa

vinay_hg — Wed, 03 Sep 2014 08:30:34 GMT

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 .

tresB — Wed, 03 Sep 2014 08:34:32 GMT

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));