Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have created missing date using below logic. But while selecting another field, date values doesn't working properly.
FROM [lib://AttachedFiles/Retail Data.xlsx](ooxml, embedded labels, table is Sheet1);
MinMaxDate:Load Min (link_Date ) as MinDate ,Max (link_Date ) as MaxDateresident ETBR;Let vMinDate = Peek('MinDate',-1,'MinMaxDate') - 1;Let vMaxDate = Peek('MaxDate',-1,'MinMaxDate');
Join (ETBR)Load Date(recno()+$(vMinDate)) as link_DateAutogenerate vMaxDate - vMinDate;
above script generates all the missing but while selecting 'Enquiry Type' field, missing dates are not coming, only values in the table are coming.
if select ''Enquiry Type'' = M2ALL then ,I want ouput as mentioned below.
Kindly help to solve this issue.
what is the expected output if u select M2ALL ?
This is my expected output if i select M2ALL
1. Have you confirmed that all those dates are now in the data?
2. Have you tried 'Include null values' option on the Dimensions and 'Include zero values' on the chart?