topic Future Calender in QlikView

Future Calender

Mon, 21 Mar 2016 07:47:26 GMT

I have a date field and a count

Future date count of value

21-03-2016 12

27-03-2016 11

28-03-2016 2

29-03-2016 3

30-03-2016 6

10-04-2017 7

17-05-2017 3

18-06-2018 4

26-08-2018 2

i want a master calender i which, i want

date

week history (which gives total count at the end of the week)

month history (which gives total count at the end of the month)

Re: Future Calender

Chanty4u — Mon, 21 Mar 2016 07:49:05 GMT

chk dis

The Master Calendar

Re: Future Calender

its_anandrjs — Mon, 21 Mar 2016 08:19:24 GMT

Try to create the Calendar this ways

LET vDateMin = Num('01-01-1980');

let vDateMax = Num('26-08-2018');

Calender:

LOAD

Distinct

Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY') AS Date,

month(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Month,

year(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Year,

monthname(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Monthname,

Week(Date($(vDateMin) + RowNo() - 1,'DD-MMM-YYYY')) AS Week

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);

Regards,

Anand

Re: Future Calender

MayilVahanan — Mon, 21 Mar 2016 08:28:39 GMT

Try like t his

MinMaxTemp:

Load Min(FutureDate) as MinDate, Max(FutureDate) as MaxDate resident yourtablename;

LET vDateMin = Peek('MinDate');

Let vDateMax = Peek('MaxDate');

Calender:

LOAD *,

month(FutureDate) AS Month,

year(FutureDate) AS Year,

monthname(FutureDate) AS Monthname,

Week(FutureDate) AS Week

Load Date($(vDateMin) + IterNo() - 1,'DD-MMM-YYYY') AS FutureDate

AutoGenerate 1 While $(vDateMin) + IterNo() - 1 <=$(vDateMax);

Hope it helps

Re: Future Calender

MayilVahanan — Mon, 21 Mar 2016 08:29:20 GMT

Then Use

Week and Month as Dimension