topic Need Previous Financial Days. in QlikView https://community.qlik.com/t5/QlikView/Need-Previous-Financial-Days/m-p/1069341#M921867 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This expr get the values of previous financial year</P><P>=if(Count({&lt;SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=&gt;}[MASTER REFERENCE CATEGORY CODE])&gt;0,count(distinct {&lt;SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=&gt;}BILLDATE))</P><P></P><P>But all i need is 'Previous FY's counting of days' that mean if i select 2 days it'll be shown 2, and 3 for 3 and so on. Ho do i do this for</P><P>date, help me out guys</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123496_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Need Previous Financial Days. https://community.qlik.com/t5/QlikView/Need-Previous-Financial-Days/m-p/1069341#M921867 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>This expr get the values of previous financial year</P><P>=if(Count({&lt;SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=&gt;}[MASTER REFERENCE CATEGORY CODE])&gt;0,count(distinct {&lt;SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=&gt;}BILLDATE))</P><P></P><P>But all i need is 'Previous FY's counting of days' that mean if i select 2 days it'll be shown 2, and 3 for 3 and so on. Ho do i do this for</P><P>date, help me out guys</P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123496_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-Previous-Financial-Days/m-p/1069341#M921867 2020-11-25T16:16:04Z