CAN ANYONE MAKE THIS EXPRESSION CORRECT .. - Qlik Community

Report Inappropriate Content · ‎2010-09-22

<body> =COUNT( {1<YM={">=$(=MonthName(DATE('28/08/2001')))<=$(=MAX(YM))"},'$(Datediff)'=">(='90')">} DISTINCT AID)</body>

gandalfgray · ‎2010-09-22

... and what are you trying to accomplish?

Report Inappropriate Content · ‎2010-09-22

Hi Goran,

I NEED TO CALCULATE APPLID SINCE THEIR VERY FIRST DATE THAT IS (28 AUG 2001) TO TILL MY SELECTED MONTH ,ALSO IF THEIR DATE DIFFERECE (FIRST DISB DATE-SLECTED DATE) >90 THEN COUNT APPLID .

SO THERE ARE TWO CONDITION :

1. COUNT ALL FILES FROM 2001-AUG TO TILL MY SELECTED DATE.

2. THEIR DIFFERECE(FIRST DISB DATE-SELECTED DATE) SHOULD BE GREATER THAN 90 ,

THEN COUNT ALL APPLID AND GIMME RESULT......

Now any suggestion as everything is clear in front of You.......

suggest me that expression of greater than(datediff >90 --- how to write it)in set analysis....

Waiting for your reply...

Regards,

Dushyant