topic Re: Calender issue in QlikView

Calender issue

ravindraa — Tue, 01 Dec 2015 06:33:52 GMT

Hi all,

I have struck one place please give me suggestion on this to come out.

i have 3 fields one custid ,calender and sales filed , here the problem is if i select Jan month it should be display only 20 days even though it has 31 days, like wise for Feb it should be display 15 days ......

Please give me suggion on this

Please find the attached doc

Thanks in advance....

Re: Calender issue

Tue, 01 Dec 2015 06:46:05 GMT

Hi,

Can you give more clarity on the requirement?

Why you want only 20 days selected when you select Jan? Is there any pattern or you want it to be done

based on some other fields?

Put more light on the requirement.

Regards,

Reshma.

Re: Calender issue

Anonymous — Tue, 01 Dec 2015 06:55:23 GMT

Is their any logic for 20 days of Jan and 15 days of Feb??

Re: Calender issue

marcus_sommer — Tue, 01 Dec 2015 06:58:01 GMT

If you want only display dates which are workingdays or similar (however they are defined) - you should use a specialized field within a master-calendar. I think this could be helpful for you: Master Calendar with movable holidays

- Marcus

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 07:00:02 GMT

Hi Balaraj,Ahlawat,

if i select jan it should be select 1 to 20 days , then if i select Feb Jan-21 to Feb-15 it should be disaplay in my chart like if i select Mar it should be display Feb-16 to Mar-15 like wise for all month........please give me suggesion for 2 months how i have to proceed.

Thanks & Regards

Reavi

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 07:01:05 GMT

Hi Reshma Paturi,

Thanks & Regards

Reavi

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 07:04:10 GMT

Hi Marcus Sommer,

It is not related Removing holidays list from date list ,

Thanks & Regards

Reavi

Re: Calender issue

marcus_sommer — Tue, 01 Dec 2015 07:56:20 GMT

This meant you need an offset of days to a defined month. The best place for creating this is in a master-calendar (if it's quite generic) or as an additionally table associated to the master-calendar which in your case seemed to be the easiest way (small excel-table with date (+1) and then manually matching the offset-month per copy + paste which could be done in a few minutes even for years).

- Marcus

Re: Calender issue

settu_periasamy — Tue, 01 Dec 2015 08:03:10 GMT

Hi Ravi,

May be, Like this you Need..

Calender:
LOAD *, if(C_Month='Jan' and Days<=20, C_Month,
  if(Days>=16  and C_Month<>'Dec',Month(AddMonths(Calender,1)),
  if(Days<=15 ,Month(AddMonths(Calender,0))))) as NewMonth;


LOAD *,
 Day(Calender) as Days
 ;


LOAD *,RecNo() as Key,
 month(Calender) as C_Month,
 year(Calender) as C_year;


LOAD Custid, 
     Calender, 
     sales
FROM
[Sample Excel.xlsx]
(ooxml, embedded labels, table is Sheet3);

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 09:18:43 GMT

Hi Settu_Periasamy,

Yes exactly i want this one only, but if i select Dec it is not showing for jan Month wise

Thanks In advance

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 09:47:31 GMT

Hi Settu_Periasamy,

Could you please give me suggestion for other months, it is not working which i am writing in my application.

Thanks in advance

Re: Calender issue

ravindraa — Tue, 01 Dec 2015 10:29:00 GMT

Hi Settu_Periasamy,

Please give me suggestion for Mar and Apr , For Jan and Feb it is working fine .

For March it should be display 1 to 25 and Feb 16 to 28 also

for Apr it should be display 1 to 15 and March 26 to 31

Kinldly give me suggestion ....

thanks & Regards

Ravi