Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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