topic Re: Strange in QlikView

Strange

Thu, 20 Jun 2013 12:58:57 GMT

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?

Re: Strange

swuehl — Thu, 20 Jun 2013 13:01:04 GMT

Go to Settings - User Preferences - Save tab and check your backup options.

Re: Strange

Thu, 20 Jun 2013 13:08:27 GMT

it's showing Use Bachup radio button is checked and Keep Selected older

Instances radio button also checked and Keep Last =1 instance

Re: Strange

Thu, 20 Jun 2013 13:25:06 GMT

Setting>User Preferences>Save Tab

Then Just uncheck "Use Backup"

Regards-Bika

Re: Strange

Thu, 20 Jun 2013 13:39:53 GMT

Thanks

Its working

Re: Strange

Thu, 20 Jun 2013 13:42:37 GMT

Hi,

what almost all qv files are in Timestamp(date) , num(date()) why can't we take as it is like date?

Re: Strange

Fri, 21 Jun 2013 09:24:06 GMT

Hi check...Hope it will help u...

Setting>Document Properties>General> Just Uncheck Timestamp inLogfile Name

Regards-Bika

Re: Strange

Fri, 21 Jun 2013 11:44:29 GMT

Thanks for this.

Hi,

Can anyone tell when I am creating master calendar qvd it's taking

fiscalyears from 1900-2013. earlier it is fine now I cahnged my access

database from mdb to accdb. I don't understand why it is taking years from

1900 could anyone let me know what's the problem as it is very urgent as I

need to upload this into access point.

Re: Strange

swuehl — Fri, 21 Jun 2013 12:32:38 GMT

amelia2000,

It's hard to answer your question without knowing how you actually generate your master calendar (and without knowing your source data, of course).

I assume you create your master calendar range by determining the min and max date of a field.

It looks like your minimum date is evaluated to near zero, because in QV, dates have a numeric representation that starts with 30 Dec, 1899.

Please double check the creation of your date range lower limit in the code part that creates your master calendar.

Re: Strange

Fri, 21 Jun 2013 13:53:55 GMT

Hi,

I created Fiscal year and Date like below:

YearName(Date,0,7) as FiscalYear

and

date#(date(date)) as Date

LET VarMinDate=Num(Peek('MinDate',-1,'MinMax')

LET VarMaxDate=Num(Peek('MaxDate',-1,'MinMax')

here VarMinDate and VarMaxDate are variables.

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

Is this the problem? please help as it is urgent?

Re: Strange

Fri, 21 Jun 2013 14:05:47 GMT

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;

Re: Strange

swuehl — Fri, 21 Jun 2013 14:10:22 GMT

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

Re: Strange

Fri, 21 Jun 2013 14:12:17 GMT

MinMax:

LOAD

Max(Timestamp(DateLogged)) as MaxDate,

Min(Timestamp(DateLogged)) as Mindate

FROM xx.qvd

how can I change?

Re: Strange

Fri, 21 Jun 2013 14:18:05 GMT

You want me to change

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

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

Re: Strange

swuehl — Fri, 21 Jun 2013 14:23:40 GMT

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

Re: Strange

Fri, 21 Jun 2013 14:44:44 GMT

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

Re: Strange

Tue, 25 Jun 2013 12:23:30 GMT

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

Re: Strange

Tue, 25 Jun 2013 14:49:17 GMT

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?