topic Re: expression in QlikView

expression

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

Hi All,

Can someone explain me what the below statement mean ? ( this is written in the srcipt)

Month(MakeDate(left(salesMonth,4),right(salesMonth,2))) AS Date_Sales_Month,

Thanks in Advance

Re: expression

marcus_sommer — Wed, 17 May 2017 06:36:45 GMT

It takes from a value like 201705 the first 4 chars (year) and the last 2 chars (month) to create per makedate() a date which is then transformed to a month-value of 'May'.

- Marcus

Re: expression

smilingjohn — Wed, 17 May 2017 06:38:08 GMT

Hi Marcus,

Thanksn for the reply ..It will be really helpfull if you can give me an example .

Thanks

Re: expression

marcus_sommer — Wed, 17 May 2017 06:43:45 GMT

It's logically like the following order - here for demonstration reasons created as preceeding load:

load month(Date) as MonthOfsalesMonth;

load makedate(Year, Month) as Date;

load left(salesMonth, 4) as Year, right(salesMonth, 2) as Month;

load 201705 as salesMonth autogenerate 1;

whereby the above expression will do the same within a single load just nesting those functions.

- Marcus

Re: expression

Kushal_Chawda — Wed, 17 May 2017 06:48:01 GMT

Let's say you have Value like 201705 in salesMonth

left(salesMonth,4) will give you 2017

right(salesMonth,2) will give you 05

MakeDate(left(salesMonth,4),right(salesMonth,2)) -> MakeDate(2017,05) will give you 1/05/2017 (1st May 2017)

Month(MakeDate(left(salesMonth,4),right(salesMonth,2))) -> Month (1/05/2017) will give you May

If you wanna make expression simple use below expression

month(date#(salesMonth,'YYYYMM'))

Re: expression

sanjay006 — Wed, 17 May 2017 06:52:46 GMT

Refer this !