topic Re: Writting a Date range in an expression in QlikView

Writting a Date range in an expression

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

Hi,

I have to write an expression in which I need to know the sales based on given date range

Here I need to know the sales lets say one week prior to Diwali date

Diwali date is basically an internal table maintained in Qlikview (field names as lastDate as shown in image.

so if I have to write an expression

here Diwali date ie( lastDate name has been changed by changing label name as previous year ) will be treated as start date and for end date the no of days which will be entered by user

say 9 the corresponding date ie 10/10/2017 + 9 =10/1/2017 will be treated as end date.

and here 10/1/2017 is taken in a variable (DaysOfComp) as shown below

Please help how to write an expression for the above scenario?

Re: Writting a Date range in an expression

sakshikaul — Wed, 31 Oct 2018 09:42:19 GMT

help Please stalwar1‌

Re: Writting a Date range in an expression

sunny_talwar — Wed, 31 Oct 2018 11:03:22 GMT

Would you be able to share the app you are working with?

Re: Writting a Date range in an expression

sakshikaul — Wed, 31 Oct 2018 11:16:00 GMT

Please help me in attaching the application ?

i am not able to see advanced editor option from where i can attach a document

Re: Writting a Date range in an expression

sunny_talwar — Wed, 31 Oct 2018 11:17:39 GMT

Are you replying from the inbox? You need to come to come to this link Writting a Date range in an expression and then respond

Re: Writting a Date range in an expression

sakshikaul — Thu, 01 Nov 2018 04:23:18 GMT

InlinetableLastYear:
LOAD
Date(Date#(InlineDate, 'DD/MM/YYYY'), 'DD MMM YYYY') as lastDate
INLINE [
InlineDate,event
10/10/2018,Diwali
];

In this inline table why I am not able to see this event column ?

Re: Writting a Date range in an expression

tharanikannan — Thu, 01 Nov 2018 05:15:10 GMT

Hi Sakshi,

please add event to your load script also.

InlinetableLastYear:

LOAD

Date(Date#(InlineDate, 'DD/MM/YYYY'), 'DD MMM YYYY') as lastDate,

event

INLINE [

InlineDate,event

10/10/2018,Diwali

];

Re: Writting a Date range in an expression

prma7799 — Thu, 01 Nov 2018 10:52:27 GMT

may be like this

LOAD

Date(Date#(InlineDate, 'DD/MM/YYYY'), 'DD MMM YYYY') as lastDate , event

INLINE [

InlineDate,event

10/10/2018,Diwali

];