Strange

[#1]

Hi,

can anyone let me know why it's happening..

when I am creating any qvw file after sometime if I save or of i close and reopen how many time sI am doing this that many times it is creating like version of 1,version of 2,version of 3 etc and it is completely filling my folder and this is very frustating me. could anyone help me in this?

[#2]

Hi,

pls find below process..hope it will help u..

Temp:

LOAD
     num(min(DATE)) AS MinDate,
     num(max(DATE)) AS MaxDate
RESIDENT DataBase;                  // Table Name

LET vMinnDate = peek('MinDate', 0, 'Temp');

DataTemp:

date(yearstart($(vMinnDate)+ rowno()- 1,0,4),'YYYY') as YearFin

AUTOGENERATE
     vMaxxDate - vMinnDate + 1;

Regards-Bika

LET vMaxxDate = peek('MaxDate', 0, 'Temp');
DROP TABLE Temp;

[swuehl]

I observed in the settings->variable overview there is no value for VarMindate.

Yes, this is part of the problem.

You'll need to step through your code, using the debug dialog and/or some additional TRACE statements.

Looks like your MinDate field in MinMax table doesn't hold a correct date value (so Num(Peek(...)) will not work, either because the Peek failed (no value at all) or the Num function (no numeric value).

[#4]

Hi

MinMax:

    LOAD

        Max(Timestamp(DateLogged)) as MaxDate,

        Min(Timestamp(DateLogged)) as Mindate

     FROM xx.qvd

how can I change?

[#5]

You want me to change

let varmindate=num(min('mindate',-1,'minmax))

let varmaxdate=num(max('maxdate',-1,'minmax'))

[swuehl]

MinMax:

    LOAD

        Max(Timestamp(DateLogged)) as MaxDate,

        Min(Timestamp(DateLogged)) as Mindate

     FROM xx.qvd

You don't need to format your DateLogged field using Timestamp() function, if you want to find the Max value.

You may need to interpret your DateLogged field using Timestamp#() function, though.

I suggest you step one step back and read:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right

resp.

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar

These two classic blog posts should clarify your issue.

Regards,

Stefan

[#7]

Thank You so much . just script error I made small 'd' instead of 'D'.

[#8]

Hi

I created report in my qvw file but I am not able to generate as pdf in access point. what could be the reason? can anyone please help me its very very urgent

please could anyone help in this

[#9]

Hi

when I am creating document report i am not able to see the all the pages

information at a time . if i selected one page only it is displaying.could

anyone tell what's the reason?