topic AW:Re: Change_Date & Create_Date in QlikView

Change_Date & Create_Date

Mon, 22 Nov 2010 09:46:53 GMT

Hi,

Says i have a flat table, with Change date and Creation date of a row.

i need to create a table with month as dimension.
How can i let Change date /Creation date to fall into the right month in the table?

obviously i can't just use the month either from change / creation date.

Change_Date & Create_Date

Miguel_Angel_Baeyens — Mon, 22 Nov 2010 09:57:55 GMT

Hello Nick,

You will need two month fields, one for Change date, the other for Creation date, and you will use one of both as dimension depending on the analysis you want to return (select all items where change date falls into january or select all of them that where created in january).

You can let the user select the calendar and using variables to use a variable as dimension that stores the selection of the user.

Check this file and see if that helps.

Regards.

Change_Date & Create_Date

sparur — Mon, 22 Nov 2010 10:01:04 GMT

Hello Nick.

why you can't use like as:

month(Create_Date) as Month

month(Cange_Date) as Month

AW:Re: Change_Date & Create_Date

brenner_martina — Mon, 22 Nov 2010 12:58:25 GMT

Hi,

better you create a standallone calendertable with all Datefunctions you need, esp. startmonth and endmonth and in the expression you can use if-then-statements for aggregations:

Sum(If(startmonth<=Create_Date and Create_Date<=endmonth, sales, 0))

dito for Change_Date

Or set analysis ...