topic Re: Need help on expression in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-expression/m-p/332653#M122595 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I am attaching an example that I think can solve your problem.</P><P></P><P></P><P>I modified the script to make that calculation to load the Excel file.</P><P></P><P></P><P>Now you tell me if it's solution.</P></BODY></HTML> Wed, 04 Jul 2012 10:03:26 GMT 2012-07-04T10:03:26Z Need help on expression https://community.qlik.com/t5/QlikView/Need-help-on-expression/m-p/332652#M122594 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>How to calculate the number of days, each store has been stocked out continuously</P><P></P><P>Ex. store-A had stock on 1-jun and 3-Jun and there were no stock on 2-Jun, 4-Jun and 5-Jun.</P><P>Now I need to show like as of 5-Jun, the particular store has been continuously stocked out for 2 days. </P></BODY></HTML> Tue, 03 Jul 2012 18:41:05 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression/m-p/332652#M122594 2012-07-03T18:41:05Z Re: Need help on expression https://community.qlik.com/t5/QlikView/Need-help-on-expression/m-p/332653#M122595 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>I am attaching an example that I think can solve your problem.</P><P></P><P></P><P>I modified the script to make that calculation to load the Excel file.</P><P></P><P></P><P>Now you tell me if it's solution.</P></BODY></HTML> Wed, 04 Jul 2012 10:03:26 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression/m-p/332653#M122595 2012-07-04T10:03:26Z