topic Re: Calendar in QlikView

Calendar

Sun, 01 Feb 2015 11:57:40 GMT

one of table i have contain

productid, createdate, saledate

another table is calendar to filter out the product accordingly table have year quarter month week and key

i want to control both createdate and saledate ...how it is possible... can you please share ur ideas

Re: Calendar

Colin-Albert — Sun, 01 Feb 2015 12:19:25 GMT

Have a look at this postCanonical Date

Re: Calendar

Anonymous — Sun, 01 Feb 2015 12:42:55 GMT

Hi,

Use below logic:

LOAD
productid,
createdate,
createdate as commondate
From table;

Concatenate

LOAD
productid,
saledate,
saledate as commondate
From table;

use commondate in master calendar

Re: Calendar

MarcoWedel — Sun, 01 Feb 2015 12:49:02 GMT

http://community.qlik.com/message/705017#705017

Hope this helps

Regards

Marco

Re: Calendar

Sun, 01 Feb 2015 18:41:18 GMT

i have list box for year month week at Dashboard...

means i am the 1 user - i want to see the records in chart filter by createdate

and second user want to see the records in chart filter by saledate

but i have single calendar list box how can i use that list box (having calender filter) , separately for both

.....

i am thinking of the button and variables

and list box will use the expression with variables

is it a good scenario to use a calendar filter for two fields?

Re: Calendar

maxgro — Sun, 01 Feb 2015 18:57:50 GMT

why not 2 calendar?

Why You sometimes should Load a Master Table several times

Re: Calendar

Mon, 02 Feb 2015 07:01:20 GMT

But i dont want to see repeated list box for - Month,Year, Quarter on my dashboard..

i am using straight chart for report....

expression is hidden

in dimension various column i have, including createdate and updatedate

if user select calendar suppose year = 2013

record should filter out which are created in 2013 year

this is the normal behaviour

now user also want to filter data from same list box according to updatedate instead of createdate

Re: Calendar

Michiel_QV_Fan — Mon, 02 Feb 2015 07:31:03 GMT

Consider a date island and the needed set analysis that goes with that.

Using a date island you create a not linked calender first which covers the whole date range.

For instance:

// Load the Date Island

Let vStartDate=Floor(MakeDate(1921));

//Let vEndDate=Floor(MakeDate(2015,12,31));

let vEndDate = Floor(addyears(YearEnd(today()), 1));

Let vDiff=vEndDate-vStartDate+1;

DateIsland:

Load

date(TempDate) as DateIslandID

Year(TempDate) as Year,

Year2Date(TempDate, 0, 1) as CurrentYtd,

num(Month(TempDate)) As Monthnr,

week(TempDate) as Week,

ceil(month(TempDate)/3) as Quarternr;

Load

$(vStartDate)+RecNo()-1 As TempDate

AutoGenerate($(vDiff));

In your expressions you add something like this:

sum({<createdate={">=$(=min(DateIslandID))<=$(=max(DateIslandID))"}>}amount)

sum({<saledate={">=$(=min(DateIslandID))<=$(=max(DateIslandID))"}>}amount)

Re: Calendar

MarcoWedel — Mon, 02 Feb 2015 07:33:06 GMT

Hi,

when implementing a canonical date calendar e.g. like Colin suggested, you get a date type field where users can select the type "updatedate" or "createddate".

Hope this helps

Regards

Marco