topic Re: how to write expression in QlikView

how to write expression

kunkumnaveen — Tue, 22 Nov 2016 05:44:07 GMT

Hello Everyone,

can anyone help me in correcting this expression plz ,i have no clue where it is going wrong

when i use the Ceil expression(if(ceil(Day/7)>4,4,ceil(Day/7)) as Week) i am getting the values like

but what i am looking is

Week1

Week2

Week3

Week4

that is the reason why i am trying this expression

Expression:

If(Day<=7, Dual('Week1', 1),

If(Day<=14, Dual('Week2', 2),

If(Day<=21, Dual('Week3', 3),

If(Day<=31, Dual('Week4', 4))))) as Week

but something is missing from this expression , can suggestion plz

Re: how to write expression

eromiyasimon — Tue, 22 Nov 2016 05:50:26 GMT

hi naveen,

kindly add your QVW.

Re: how to write expression

kunkumnaveen — Tue, 22 Nov 2016 05:54:09 GMT

Hi,

i cant do that bro ,

Re: how to write expression

tamilarasu — Tue, 22 Nov 2016 06:01:29 GMT

Hi Naveen,

I think you missed to add Field name "Day" in first "If" statement. Try this,

Load *,
If(Day<=7, Dual('Week1', 1),
If(Day<=14, Dual('Week2', 2),
If(Day<=21, Dual('Week3', 3), Dual('Week4', 4)))) as Week,
Dual(Date(Date,'MMMM'),Month(Date(Date,'MMM'))) as Months
Resident Coal;

Drop table Coal;

Re: how to write expression

kunkumnaveen — Tue, 22 Nov 2016 06:05:56 GMT

yes ,my bad thanks for the help