Difficult Logic

[smilingjohn]

Hi Expertise , 

For me this is becoming really very difficult . Please find the attachment of the  QVW and Excel sheet . I have two dates 

one is "TakenDate" and the other one is "Updated" . Now i want to have a one field of year and month and upon selecting the year and month it should give me the data related to that year and month .  

For example i select May month then it should show me all the records in the month of may . ( SOme are from TakenDate and some are from Updated) . 

[martinpohl]

So you have to load your data two times

load 

ID,

severity,

'taken' as time_type,

takendate as date

from your data;

load 

ID,

severity,

'updated' as time_type,

updatedate as date

from your data;

then create a master calender from field date.

The field time_type is to identify how many creations and updates are in the period.

Regards

[smilingjohn]

Thanks @ martinpohl

 If you can please use the excel sheet and give me the example it would really be helpfull .

Thanks 

[smilingjohn]

@martinpohl  I have implemented your logic but it shows double records . Can you please look into the attachment . 

Thanks

[martinpohl]

sure there are double records. but there is the time_type-field, so you only have one type for each record....

[smilingjohn]

But i want to show those dates from time_type field which falls in may . 

Is this possible ? Becuase that is what exactly i want when i click on the month  it should filter out those dates falling under that month .

[smilingjohn]

Hi Community,

Any help on this ?

[Kushal_Chawda · Accepted solution]

@smilingjohn  refer below

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578