Solved: Re: Set Expression - Qlik Community

upaliwije · ‎2017-08-21

Dear Friends

My following set expression show zero results. I think there is an error there. Pls help me to rectify it

Anil_Babu_Samineni · ‎2017-08-21

May be this? I assume Date fields are good

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {"=$('<' & =Max(RENEWED_DATE))"}>} DISTINCT POLICT_NO)

OR

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {'<$(=Max(RENEWED_DATE))'}>} DISTINCT POLICT_NO)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-08-21

May be this? I assume Date fields are good

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {"=$('<' & =Max(RENEWED_DATE))"}>} DISTINCT POLICT_NO)

OR

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {'<$(=Max(RENEWED_DATE))'}>} DISTINCT POLICT_NO)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

upaliwije · ‎2017-08-21

Thanks Anil

Your second option works

Anil_Babu_Samineni · ‎2017-08-21

I think first one also should work, May be remove = sign for your understand you can learn yourself

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful