Solved: How do I work out percentage in expression - Qlik Community

Report Inappropriate Content · ‎2012-10-02

Hi, I need to work out a % of a number in an expression and this just isnt working :-

count(if(len([Default Notice Date]>'0'),BP)/count(if(len([Registration Date]>'0'),BP)*100))

MayilVahanan · ‎2012-10-02

HI

Try like this

count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

MayilVahanan · ‎2012-10-02

HI

Try like this

count(if(len([Default Notice Date]>'0'),BP))/count(total if(len([Registration Date]>'0'), BP))

hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.