the tables don't have calendar , how to add calendar measures to the tables ?

[emmanuelanurag]

I extract the DQT(DATA QUALITY Tables) from the SQL server to Qlik sense, but the tables don't have calendar measures to show the monthly trend whether the values are increasing or decreasing, can you please help me with this issue.

[rubenmarin]

Hi, you can take a look at this video on how to create a master calendar. It's quite old but the basis are the same.

https://www.youtube.com/watch?v=ek_ITfvCnHw

[emmanuelanurag]

Hi,  thanks for your response, but the tables don't have dates, So it's hard for me to generate calendar measures.

[rubenmarin]

Hi, if that's like a snapshot where there is only a situation on one date you'll need to add the date to each dataset extracted from SQL. Doing an incremental load to add data from different dates, once you have data from different dates you can do the evolution chart.

[emmanuelanurag]

Thank you and will try to do accordingly