topic Re: help reducing script in QlikView https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767227#M272537 <HTML><HEAD></HEAD><BODY><P>Can you provide FinanceDate Table excel file?</P></BODY></HTML> Sun, 22 Feb 2015 12:13:37 GMT MK_QSL 2015-02-22T12:13:37Z help reducing script https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767226#M272536 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I have been struggling with a date issue, creating the right finance date. I have now got a solution that works and seems to give me the right FinanceDate, in a lot of different situations.</P><P></P><P>But I think the script could be done in a "easier" way, I just can't get it right <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>so do any one of all you great Qlikers have another solution</P><P></P><P>Attached example qvw and data file</P><P></P><P>Regards</P><P>NJ</P></BODY></HTML> Sun, 22 Feb 2015 11:29:28 GMT https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767226#M272536 2015-02-22T11:29:28Z Re: help reducing script https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767227#M272537 <HTML><HEAD></HEAD><BODY><P>Can you provide FinanceDate Table excel file?</P></BODY></HTML> Sun, 22 Feb 2015 12:13:37 GMT https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767227#M272537 MK_QSL 2015-02-22T12:13:37Z Re: help reducing script https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767228#M272538 <HTML><HEAD></HEAD><BODY><P>Hi Manish</P><P></P><P>Other Finance dates is comming from another sales table, with all dates for month and year, where this is concatenated to.</P><P></P><P>So it would just be all dates, and shouldn't matter here</P><P></P><P>regards</P><P>NJ</P><P></P><P><BR /> </P></BODY></HTML> Sun, 22 Feb 2015 12:58:39 GMT https://community.qlik.com/t5/QlikView/help-reducing-script/m-p/767228#M272538 2015-02-22T12:58:39Z