Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Previous Financial Days.

Hi All,

This expr get the values of previous financial year

=if(Count({<SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=>}[MASTER REFERENCE CATEGORY CODE])>0,count(distinct {<SalesFY={$(=max(SalesFY)-1)},ITEM={'GOLD'},fYear=>}BILLDATE))

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

date, help me out guys

0 Replies