Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Future Calender

Hi

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)

4 Replies
Chanty4u
Esteemed Contributor III

Re: Future Calender

Re: Future Calender

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

Hi

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

Then Use

Week and Month as Dimension