Qlik sense selction

[ranjitalenka]

Hi,

I have uploaded data for November, INnqlik it is showing upto october.In selection panel also november month is not showing.How to solve the issue or add november month in selection panel

[abhijitnalekar]

Hi @ranjitalenka,

Have you reloaded the app?

what is the source of the data? Excel or SQL?

[ranjitalenka]

excel

[ranjitalenka]

I believe call month is note getting activated

calender code

[MAX MIN]:
Load
MAX(#CallDate) AS MAX_Date,
MIN(#CallDate) AS MIN_Date

RESIDENT [LINK TABLE];

LET vMaxDate = num(PEEK('MAX_Date',0,'MAX MIN'));

LET vMinDate = num( PEEK('MIN_Date',0,'MAX MIN'));

Drop table [MAX MIN];

TempCalendar:

load

$(vMinDate) + Iterno()-1 AS num,
Date($(vMinDate)+ IterNo()-1) as TempDate
AutoGenerate 1 while $(vMinDate) +IterNo()-1<=$(vMaxDate);

Calender:
LOAD
TempDate AS #CallDate,
DAY(TempDate) AS [#Call Day of Month],
MONTH(TempDate) AS [#Call Month],
YEAR(TempDate) AS [#Call Year],
MONTH(TempDate) & '-' & YEAR(TempDate) AS [#Call Year-Month],
Week(TempDate) AS [#Call Week],
AutoNumber(MONTH(TempDate) & YEAR(TempDate)) AS [#Call MonthSerial],
WeekDay(TempDate) AS [Week Day],
Dual('Q' & Ceil(Month(TempDate) / 3), Ceil(Month(TempDate) / 3)) as [#Call Quarter]

Resident TempCalendar;

drop table TempCalendar;

link table code

********

Load
Esc_Number,
Escalation_Date as [#CallDate]
Resident Escalation;

there are other 3,4 files.but when i am uploading this file call month is not getting activated.

[abhijitnalekar]

Hi @ranjitalenka ,

Can you please check the date format or please confirmEscalation_Date the date in excel is in date format..
As I can understand from the code, the master calendar is excluding the new data and that could be because of the not proper data type of the particular field

[ranjitalenka]

Hi Abhijit,

The Escalation_date is in date format,but why it is not included ,I am uable to understand.