Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
RishabhTFC
Contributor III
Contributor III

Date Not Showing

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

Unqualify *;

[Final TB 2_temp_f534b951-8961-e226-cb57-b218c850]:
LOAD
	[Acc_ID],
	[BS / P&L],
	[Account type],
	[Expense Type],
	[TB.Head],
	[Sub-Head],
	[TB.Particulars],
	[Vert1],
	[TB.Type],
	[Vertical],
	[Process Name],
	[MonthEnd] AS [Month_Date],
	[Amt]
RESIDENT [Final TB 2];
DROP TABLE [Final TB 2];

[SALARY_temp_33e701b9-50cc-e2a2-9c23-21bca65e]:
LOAD
	[Name],
	[S_Date] AS [Month_Date],
	[Salary]
RESIDENT [SALARY];
DROP TABLE [SALARY];

[Head Count_temp_10994835-67bc-f44d-6f4a-6f147bd1]:
LOAD
	[Head Count.Type],
	[Head Count.Process],
	[H_type],
	[H_Date] AS [Month_Date],
	[H_Value]
RESIDENT [Head Count];
DROP TABLE [Head Count];

[Fixed_temp_b67ee582-f744-22d7-cdb2-9fef83fe]:
LOAD
	[Fixed.Particulars],
	[F_type],
	[Fix_Date] AS [Month_Date],
	[Fix_value]
RESIDENT [Fixed];
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 : 

calender.JPG

The data loads but the problem is only Month_Date field works the year and Quarter doesn't in  the App.

App.JPG

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.

 

Thanks

SG

 

1 Reply
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

hello,

it is strongly recommended to create a master calendar.

url :"https://community.qlik.com/t5/QlikView-Scripting/Creating-A-Master-Calendar/td-p/341286"

it's the same on Qlikview and Qliksense.

bye