Use of greater than sign at set analysis expression

[#1]

Hi All,

I am having one intresting problem in set analysis expression,

where i am using condition like my Doc Recived Date should be greater than selected month ????

expression is like this ..

Count({$<YM={'$(vCurrentyearmonth)'},STATUS={'Deferred'},Year=,Quarter=,MonthName=>} distinct BTFILE_NO)

here i want to insert one more condition using greater than sign for date like if my( RMONTH > MONTHNAME ) THEN COUNT FUNCTION SHOULD WORK.....

Any Guess......

PLEASE FIND OUT THE APPLICATION ATTACHED FOR YOUR REFRENCE AND UNDERSTANDING.........

Please reply ASAP..... AS THIS IS VERY URGENT....

Regards,

Dushyant

[#2]

Hi Luis, Thanx for your prompt respose .....

But can you send me a single document(qvw) in which i am having my desired result BT File no for current month and previous month and previous-1 month based on First Disbursement date ,but for that condition ReciveDate should be greater than (selected month-FROM First disbursement field) or month of reciveddate <= month(first disbursement date ) then count of bt fileno for previous month ,current month ,and previous-1 months result .

All these result should be in one sheet ,there will 3 expression 1 for current another for previous ,next will be for previous-1 month ,and branch should be dimension......

For your understanding i have made 3 variables for currentmonth,previousmonth,previous-1 month.

Please do me this favour because i am not able to understand your logic you are going to apply on dimension...

please send me modified doccument with the desired changes with result...

Thanx in advance ....

Waiting for your reply.....

Regards,

Dushyant

[#3]

Hi John,

Can you tell me how to make this date comparison possible in numeric format at set analysis expression.because according to result in my expression my Recived date's month should be greater than selected month(comes from another date field that is -First disbursement Date).

Please have a look at script and suggest.........

Waiting for your reply....

Thanx in advance..

Regards,

Dushyant

[#4]

Hi Rahul, 1st Condition: I WANT A RESULT DATA TO COUNT MY ALL FILENO. (BTFILE_NO-FIELD) FROM THE FIELD (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({$} 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 AND ALONG WITH THIS STATUS SHOULD BE 'DEFERRED' EXPRESSION SHOULD BE LIKE THIS--- COUNT(IF( STATUS='DEFERRED',MONTHNAME=>MONTH(FIRST_DISB_DATE),DISTINCT BTFILE NO) THIS EXPRESSION I WANT TO USE BY APPLYING SET ANALYSIS FOR CURRENT AND PREVIOUS MONTH BOTH. 2nd condition with Union Here i am using condition like my Doc Recived Date should be greater than selected month ???? --- This selected month will come from (First_Disb_Date) expression is like this .. Count({$} distinct BTFILE_NO) here i want to insert one more condition using greater than sign for date like if my( RMONTH > MONTHNAME ) THEN COUNT FUNCTION SHOULD WORK..... RMONTH WILL COME FROM RECIVE DATE FIELD ---MONTH(RECEIEVE DATE) SHOULD BE GREATER THAN MY SELECTED MONTHNAME THEN FILE NO SHOULD BE COUNT...... MONTHNAME WILL COME FROM FIRST DISB DATE ON WHICH WE WILL MAKE SELECTION FOR YEAR AND MONTH.... PLEASE FIND OUT THE APPLICATION ATTACHED FOR YOUR REFRENCE AND UNDERSTANDING......... Please reply ASAP..... AS THIS IS VERY URGENT.... Please find out application doccument(qvw) attached for your understanding and reference......... If any problem to understand the logic and expected result please revert back........ Waiting for your reply....... -- Regards---- Dushyant Tyagi BI-Qliview /ERP(SAP) Consultant Icon Resources Group New Delhi Mail-dushyant@iconresources.com, dushyant.ntpc@gmail.com