topic Re: Error in Expression in QlikView

Error in Expression

upaliwije — Sun, 20 Aug 2017 05:41:11 GMT

Dear Friends

The following expression does not work

if(RENEWABLE>0,count(DISTINCT {<EDATE={"=$(vFdate)"}>}POLICY_NO))

Pls help me to correct it

ecolomer — Sun, 20 Aug 2017 06:25:16 GMT

But do you have a mistake Or does not give the results...

ecolomer — Sun, 20 Aug 2017 06:26:51 GMT

Check the date formats. Usually this is a common problem.

Kushal_Chawda — Sun, 20 Aug 2017 12:14:13 GMT

try this

if(RENEWABLE>0,count(DISTINCT {<EDATE={"$(=vFdate)"}>}POLICY_NO))

vinieme12 — Sun, 20 Aug 2017 12:26:55 GMT

Maybe

count(DISTINCT {<EDATE={"$(vFdate)"}>} if(RENEWABLE>0,POLICY_NO))

count(DISTINCT {<EDATE={"$(=vFdate)"}>} if(RENEWABLE>0,POLICY_NO))

count(DISTINCT {<EDATE={"$(vFdate)"}, POLICY_NO={"=RENEWABLE>0"} >} POLICY_NO)

sunny_talwar — Sun, 20 Aug 2017 12:57:15 GMT

Or this

Count(DISTINCT {<EDATE={"$(vFdate)"}, RENEWABLE = {'>0'}>} POLICY_NO)

or with equal sign

Count(DISTINCT {<EDATE={"$(=vFdate)"}, RENEWABLE = {'>0'}>} POLICY_NO)

Sun, 20 Aug 2017 13:43:40 GMT

May be

count({<RENEWABLE={'>0'}, EDATE={$(vFdate)}>} Distinct policy_no)