Calendar

[#1]

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

[Colin-Albert · Accepted solution]

Have a look at this postCanonical Date

[Anonymous]

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

[MarcoWedel]

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

Hope this helps

Regards

Marco

[#5]

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?

[maxgro]

why not 2 calendar?

Why You sometimes should Load a Master Table several times

[#7]

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

[Michiel_QV_Fan]

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)

[MarcoWedel]

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