topic Number format for showing value in % in QlikView

Number format for showing value in %

Wed, 15 Apr 2015 08:47:02 GMT

Hi All,

I am using the below formula in a text box to calculate the rate.

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) * 100,'#,##0.00%')

I am getting the value as 10.000.00% I want to show it as 100%. I have tried some other format also but it's not working.

Please suggest.

Thanks

Ashish

robert_mika — Wed, 15 Apr 2015 08:48:38 GMT

Could you post your app?

fvelascog72 — Wed, 15 Apr 2015 08:51:32 GMT

Try this:

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) ,'#,##0%')

Wed, 15 Apr 2015 08:52:26 GMT

Try like below,

num((count({$<[Lead Date]= {Yes}, [Opportunity Date]={Yes}>} [Id]) / count({$<[Lead Date]= {Yes}>} [Id])) * 100,'#.##0%')

Wed, 15 Apr 2015 09:22:47 GMT

Thanks Federico..