Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hello, I am having some problems with Dates.
Yeah So actually I had 4 sheets (Final TB 2, Salary, Head_Count, Fixed). All of them has same Dates with Different Names.
I want to Associates them with Dates and thats what I do in script as you can see below
[Final TB 2_temp_f534b951-8961-e226-cb57-b218c850]:
[BS / P&L],
[MonthEnd] AS [Month_Date],
RESIDENT [Final TB 2];
DROP TABLE [Final TB 2];
[S_Date] AS [Month_Date],
DROP TABLE [SALARY];
[H_Date] AS [Month_Date],
RESIDENT [Head Count];
DROP TABLE [Head Count];
[Fix_Date] AS [Month_Date],
DROP TABLE [Fixed];
RENAME TABLE [Final TB 2_temp_f534b951-8961-e226-cb57-b218c850] to [Final TB 2];
RENAME TABLE [SALARY_temp_33e701b9-50cc-e2a2-9c23-21bca65e] to [SALARY];
RENAME TABLE [Head Count_temp_10994835-67bc-f44d-6f4a-6f147bd1] to [Head Count];
RENAME TABLE [Fixed_temp_b67ee582-f744-22d7-cdb2-9fef83fe] to [Fixed];
All the Dates are associates Perfectly with theAssociate name as Month_Date. Now I make some tweaking by using auto calender :
The data loads but the problem is only Month_Date field works the year and Quarter doesn't in the App.
Its totally blank and not working .
Anybody has clue how to solve this issue.
I want to use Month_Date date in different format sometimes in Quarter , sometimes in year only sometimes as Month.
it is strongly recommended to create a master calendar.
it's the same on Qlikview and Qliksense.