Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Honored Contributor III

Re: How to create an column to display date ?

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

11 Replies
Not applicable

Re: How to create an column to display date ?

Hi All

Enclosed my QV doc sample.

Paul

anbu1984
Honored Contributor III

Re: How to create an column to display date ?

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

MVP
MVP

Re: How to create an column to display date ?

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

Re: How to create an column to display date ?

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 ?

Hi,

may be like this.

Regards

ASHFAQ

anbu1984
Honored Contributor III

Re: How to create an column to display date ?

Yes. Today() will give you current date.

anbu1984
Honored Contributor III

Re: How to create an column to display date ?

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

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

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

Re: How to create an column to display date ?

Hi Paul,

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

Regards

ASHFAQ

Community Browser