Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create an column to display date ?

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

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

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

View solution in original post

11 Replies
Not applicable
Author

Hi All

Enclosed my QV doc sample.

Paul

anbu1984
Master III
Master III

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

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

may be like this.

Regards

ASHFAQ

anbu1984
Master III
Master III

Yes. Today() will give you current date.

anbu1984
Master III
Master III

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

Not applicable
Author

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 ?

date update.png

ashfaq_haseeb
Champion III
Champion III

Hi Paul,

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

Regards

ASHFAQ