topic Re: inline tables functionality in QlikView

inline tables functionality

sakshikaul — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: inline tables functionality

sunny_talwar — Thu, 25 Oct 2018 11:02:23 GMT

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?

Re: inline tables functionality

sakshikaul — Thu, 25 Oct 2018 11:10:18 GMT

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

Re: inline tables functionality

sunny_talwar — Thu, 25 Oct 2018 14:55:21 GMT

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,

Re: inline tables functionality

sakshikaul — Fri, 26 Oct 2018 04:32:59 GMT

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