topic Re: date issue in QlikView

date issue

engr_farhanqadr — Thu, 19 May 2016 20:42:10 GMT

Hi Folks,

I am stuck in problem, I have sales data from 1 Jan 2016. I have made tiers of weeks , I want to start the date from 2 Jan 2016 instead of 1 jan 2016 as it was Friday. i used the script 'T' & ceil(Day([date/time])/7) &' '& Month([date/time]) as SevenD,

please help me out.

Farhan

Re: date issue

sunny_talwar — Thu, 19 May 2016 20:47:27 GMT

Not sure what the end goal is, but may be this:

'T' & Ceil((Day(Date) - 1)/7) &' '& Month(Date) as SevenD;

Re: date issue

engr_farhanqadr — Fri, 20 May 2016 21:54:27 GMT

Sunny,

it created another tier as T0 for every month and put all month first date to it which I dont want I just want the tiers to start with 2 jan 2016 instead of 1st jan 2016. just one day ahead.

Thanks

Re: date issue

sunny_talwar — Fri, 20 May 2016 23:18:38 GMT

How about April 1st? That is a Friday as well? Would you have T1 starting April 2nd for april?

Re: date issue

engr_farhanqadr — Sat, 21 May 2016 09:02:30 GMT

Sunny,

I just want to start my data from 2 jan 2016. as T1 start from 2 to 8 jan then so on and on. nothing else. all other months date as usual. let me know if you know.

Thanks