topic defualt selection in QlikView https://community.qlik.com/t5/QlikView/defualt-selection/m-p/1209270#M388157 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P></P><P>I have a expresison , that shold&nbsp; show data of yesterday, so this is applicable fo rthis month , by defualt i'm showing latest month data on dashboard, so if i will change the filter to last month , it should show 'Na'</P><P></P><P>exression :</P><P></P><P>count({&lt;NO={'Ba'},STATUS={'OPEN'},</P><P>Year={$(=max(Year))}</P><P>,[Calender MONTH]={$(=max([Calender MONTH]))},</P><P>[work_DATE] = {$(=Date(Max( {&lt; NO={'Ba'}&gt;} [workDATE])-1, 'DD/MM/YYYY'))SEQ_NO)</P><P></P><P>filter is : month year,</P></BODY></HTML> Fri, 04 Nov 2016 15:34:06 GMT yogitamehta10 2016-11-04T15:34:06Z defualt selection https://community.qlik.com/t5/QlikView/defualt-selection/m-p/1209270#M388157 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P></P><P>I have a expresison , that shold&nbsp; show data of yesterday, so this is applicable fo rthis month , by defualt i'm showing latest month data on dashboard, so if i will change the filter to last month , it should show 'Na'</P><P></P><P>exression :</P><P></P><P>count({&lt;NO={'Ba'},STATUS={'OPEN'},</P><P>Year={$(=max(Year))}</P><P>,[Calender MONTH]={$(=max([Calender MONTH]))},</P><P>[work_DATE] = {$(=Date(Max( {&lt; NO={'Ba'}&gt;} [workDATE])-1, 'DD/MM/YYYY'))SEQ_NO)</P><P></P><P>filter is : month year,</P></BODY></HTML> Fri, 04 Nov 2016 15:34:06 GMT https://community.qlik.com/t5/QlikView/defualt-selection/m-p/1209270#M388157 yogitamehta10 2016-11-04T15:34:06Z