topic How to create an column to display date ? in QlikView

How to create an column to display date ?

Tue, 27 May 2014 07:47:30 GMT

Hi All

I have a QV doc , which is compute the pricing list . and from time to time the raw data list price will be updated. for example today 27/5/2014 have new list price need to update. and i need 27/5/2014 date to be appear in one of the column. Any idea how to do it ?

Paul

Re: How to create an column to display date ?

Tue, 27 May 2014 07:49:16 GMT

Hi All

Enclosed my QV doc sample.

Paul

Re: How to create an column to display date ?

anbu1984 — Tue, 27 May 2014 08:45:46 GMT

Do you want to display current date in all the rows? Then use Today()

Re: How to create an column to display date ?

jagan — Tue, 27 May 2014 08:54:20 GMT

Hi Paul,

If you want to display Todays date in all the rows then simply use

=Today() as expression.

Hope this helps you.

Regards,

Jagan.

Re: How to create an column to display date ?

Tue, 27 May 2014 08:54:52 GMT

Hi Sir

I want to use the date I update. It is today . But after update in case tomorrow i reload again . Can the date don't change to tomorrow date ?

Paul

Sent from Samsung Mobile

Re: Re: How to create an column to display date ?

ashfaq_haseeb — Tue, 27 May 2014 08:55:14 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: How to create an column to display date ?

anbu1984 — Tue, 27 May 2014 08:57:36 GMT

Yes. Today() will give you current date.

Re: How to create an column to display date ?

anbu1984 — Tue, 27 May 2014 09:01:45 GMT

If you dont refresh daily, then add Today() in your script and use expression Max(UpdDt) to get updated date

HAKKO:

LOAD

left(FileBaseName(), 4) AS V6,

// Model,

Model as PART_NO_,

// Model as Product,

Description,

'HAKKO' AS BRAND_P,

'Fuji' as [Supplier],

'V6 & S8' as [Product Group],

S_Price as LIST_PRICE_,

S_Price as LIST_PRICE,

[Category 1],

[Category 2],

'1' as [HQuantity],

Today() As UpdDt

//FROM FCS SG TDS price list.xls (biff, header is 5 lines, embedded labels, table is [TDS$]);

//FROM V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);

FROM $(vRAWPath)V8 Price List_.xls (biff, embedded labels, table is [Ecomony Model$]);

Re: Re: How to create an column to display date ?

Tue, 27 May 2014 11:36:07 GMT

Hi Sir

I have try your approach , it work fine,Totally i have total 9 diff QV price doc all work fine , when i combine all 9 QV doc , and i use max(updDt) it display the final QV doc as number instead of date , why ? where i go wrong ?

Re: How to create an column to display date ?

ashfaq_haseeb — Tue, 27 May 2014 11:47:51 GMT

Hi Paul,

go to chart properties -->number tab-->Select update-->and select date as format.

Regards

ASHFAQ

Re: How to create an column to display date ?

anbu1984 — Tue, 27 May 2014 12:39:54 GMT

Date(Max(UpdDt),'M/D/YYYY')

Re: Re: How to create an column to display date ?

Tue, 27 May 2014 14:58:59 GMT

Hi All

Thank you vey much , it work fine now.

Paul