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

Want to count all fileno from their minimum transaction date to current selected date ??? using set analysis expression

<body>Here i want result Data in which i am having all fileNO from their (FIRST DISBURSEMENT DATE)--THESE FILES SHOULD BE COUNTED FROM THEIR MINUM DATE TO MY CURRENT SELECTION MONTH LIKE FROM MIN DATE (FIRST DISBURSEMENT DATE ) TO CURRENT SELECTED MONTH COUNT ALL FILE NOS EXPRESSION SHOULD BE LIKE THIS COUNT({$<YM={'$(vLast1YearMonth)'},Year=,Quarter= ,MIN MONTH(FIRST_DISB_DATE)<= MONTHNAME (IE..CURRENT SELECTION),MonthName=>} FILENO ) OR HOW CAN I USE BETWEEN FUNCTION IN SET ANALYSIS PROBLEM LIKE I WANT TO COUNT ALL FILES NO BETWEEN CURRENT SELECTED MONTH TO FIRST DISB DATE (MINIMUM) --- FROM TRASANCTION START VERY FIRST DATE</body>

1 Reply
Not applicable
Author

Hi All, Can anyone suggest me how to use calander object in this doccument.......

Thanx in advance,

Regards,

Dushyant