inline tables functionality

[sakshikaul]

Hi steve,

​I have to maintain an internal table in qlik view in which I have to compare last year date for Diwali with current Year date for Diwali. Following is the data to be maintained in inline table ​

LastDate      currentDate                event ​

12/10/2017   22/10/2018                 diwali​

22/11/2017    12/10/2018                durga pooja ​

so, I have maintained following above table in inline table and also ​

I have derived lastDate and CurrentDate from  (circled in black color)​

Date#(CreateDate, 'YYYYMMDD') as Sold_Date,​

date(Date#(CreateDate, 'YYYYMMDD')) as lastDate,​

date(Date#( CreateDate, 'YYYYMMDD')) as CurrentDate, ​

Following is the data model for the above ​

paint.png​

Below is the image in which date for inline table is not correct ie I am getting 10/21/4670 instead of 10/21/2017​

​

so how to make it correct?​

can we apply date function in inline table in qlikview?​

[Anil_Babu_Samineni]

Try to make it as Format

Why don’t my dates work?

Date problem

and, I also suggest don't create multi threads for single issue like

inline tables functionality

Inline tables functionality