Set Analysis expression Problem for Date comparison

Fri, 17 Sep 2010 09:17:19 GMT

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({$<YM={'$(vCurrentyearmonth)'},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.....

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.......

Set Analysis expression Problem for Date comparison

Fri, 17 Sep 2010 09:20:18 GMT

Hi All,

I am facing one problem using set analysis expression for date comparison...Please have a look and suggest me ASAP as this is very urgent requirement.......

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({$<YM={'$(vCurrentyearmonth)'},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.....

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.......

topic Set Analysis expression Problem for Date comparison in QlikView

Set Analysis expression Problem for Date comparison

Set Analysis expression Problem for Date comparison