Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
RishabhTFC
New 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
Partner
Partner

Re: Date Not Showing

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