Discussion Board for collaboration regarding Qlik DataMarket.
if quarter not complete i want to show quarter id as null
Go to Solution.
just i done but quarter in the sense 3months i want to show that in complete quarter id as null
Month(AddMonths(Date,1)) as Month,
Year(YearStart(Date,1,3)) As Year,
'Q'&Ceil(Month(AddMonths(Date,-2))/3) as Qtr,
Date(Date,'MMM-YY') as MonthYear,
Mod(Month(Date)-3,12)+1 as MonthID
DROP Table Date;
Date,Month,Qtr, AutoNumber(Year&Qtr) as YearQrID Resident Calender;
YearQrID,Count(DISTINCT Month) as MonthCout Resident Temp Group By YearQrID;
Date,YearQrID,Qtr as NewQtr Resident Temp Where MonthCout=3;
DROP Table Temp;
Could you post your data set or app?
What do you mean by not complete?
any simplification for this....