Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi steve,
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?
I am not sure what is the Inline table has to do with the date format? Are you loading them as an inline table? Can you share the inline table script?
I want to maintain an inline table like below but I need a primary key in inline table so that it can join an increment table (key will be lastDate and CurrentDate) as shown in fig
Inlinetable:
LOAD * INLINE [
LastDate, CurrentDate, Event
10/12/2017, 12/10/2018, Durga pooja
11/10/2017, 10/10/2018, Diwali
];
https://community.qlik.com/servlet/JiveServlet/showImage/2-1563211-216697/pastedImage_0.png
so how it is possible to join both the keys with increment sales and maintain this inline table in qlikview
It should join on its own, for what exactly are you using this for? What is CreateDate?
Date#(CreateDate, 'YYYYMMDD') as Sold_Date,
date(Date#(CreateDate, 'YYYYMMDD')) as lastDate,
date(Date#( CreateDate, 'YYYYMMDD')) as CurrentDate,
create date is a date used to know when last sales was done, so here create date is a column in database used as sold_date