topic Re: QV in QlikView

QV

Wed, 19 Jun 2013 15:03:24 GMT

Hi,

If we create in the script floor(date) it will display in interger form if we don't have that date in table. otherwise will it display as date( same as from date in table). can anyone clarify my doubt as I strucked here to procced further.

Re: QV

Wed, 19 Jun 2013 15:09:29 GMT

are you using floor function as shown below?

Date( Floor( Date ), 'YYYY-MM-DD') as Date

Re: QV

Wed, 19 Jun 2013 15:15:50 GMT

Hi,

The floor function used in QVD is:

Floor(date(date,'dd/mm/yyyy') as date

whereas the floor function used in live file is :

Floor(date) as date

In the live file in one table the date is taken as using floor function. And upto last month the data is fine in the file but I am nit able to see the data since last month.

urgently needed

Re: QV

Anonymous — Wed, 19 Jun 2013 17:39:48 GMT

In both cases Floor() is outsede, hence it is creating integer format. To get date format, it should be

date(floor(date))

If you want to specify format, it will be:

date(floor(date), 'dd/mm/yyyy')

Re: QV

Thu, 20 Jun 2013 09:09:35 GMT

Hi,

Means it should be like

date(floor(createdon), 'dd/mm/yyyy')

Is it right? actually my field is createdon instead of date

please consider as urgent

On Wed, Jun 19, 2013 at 6:39 PM, Michael Solomovich <

Re: QV

narender123 — Thu, 20 Jun 2013 09:15:50 GMT

Yes .You are right .Date field name is anything as you said, it is "createdon" then you can make the date as you have shown above.

So go and proceed with the same as you have written.

Thanks.

John

Re: QV

Thu, 20 Jun 2013 09:19:36 GMT

Hi John,

here I have one query.

as we are getting data upto april but from may onwards we are not able to see any data? as I observed and try to change the SQl table from old database to new database and try to reload the QVD first but surprisingly it is not allowing me to reload. Can you tell me what could be the reason?

Re: QV

narender123 — Thu, 20 Jun 2013 09:32:15 GMT

As you are getting the data up to April it means that upto april date data is present and after your qvd refresh its upto april data.Now you have converted into new sql table so means that only changes in table .

I think the problem is in your table name that you have modify as table.

For this either you have to ignore only that table by comment it or by delete from your Qvd fileas and again reload qvd.after this if it working fine that means the problem is with new table that you modified .

Thanks

Re: QV

narender123 — Thu, 20 Jun 2013 09:35:06 GMT

You also have to keep in mind that the table that you have converted ,again take that table from sql db and delete the previous one from your qvd.means create new QVD for that table.

Thanks

Re: QV

Thu, 20 Jun 2013 09:51:30 GMT

I was trying to reload entirely in different fiolder by taking the same QVD. but I changed the sql table, because the table name is same but the database is changed from old to new. now I need to use the table which exists in new database. even I tried by deleting the QVD also none is working.

Re: QV

narender123 — Thu, 20 Jun 2013 10:56:35 GMT

Fetch that sql table again in your qvw via sql connection .From that qvw create new QVD file.

Then try reload .through that QVD.

The whole thing is that u need to create again a new qvd from new sql table.

if its not working may be you need to again make the new sql connection through your oldb.