Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

Error in exp

hi,

below is my  result formulae and i used exprsn ...

( No of Defects Re-op / Total No of ref fixed ) * 100



used exp:  =num(Def_Status='Reop')/sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))*100


it shwng exprn Ok... but pie chrt values or not getting.. 

Error message:no data to dispaly


please help me the expression



Thanks in advance


Suresh




16 Replies
Not applicable

Re: Error in exp

Hi, your expression is wrong. You need count the least granular Dimension that have bithe Def_status & ref values

(count({<Def_status={"Reop"}>} Dimension_Field) / count({<ref-={"Open","New","Assigned"}>} Dimension_Field) )*100

MVP
MVP

Re: Error in exp

count({$ <Def_Status={Reop}>} Def_Status) / count( {$ <ref={Open,New,Assigned}> } ref)

sureshqv
Esteemed Contributor III

Re: Error in exp

hi dattu,

thanks for the reply it shwng the value as ''0''

(count({<def={"Reopen"}>} def) / count({<def={"Open","New","Assigned"}>} def) )*100

i need   denomenator as total num of.... if we use count for numerator it is shwng '0'

thanks in advance

sureshqv
Esteemed Contributor III

Re: Error in exp

it is not wrkng maxgro...

manojkulkarni
Valued Contributor II

Re: Error in exp

can you post some sample data

Re: Error in exp

(sum(if(Def_Status='Reop',1,0))/sum(if(ref='Open' or ref='New' or ref='Assigned', 1,0)))*100

sureshqv
Esteemed Contributor III

Re: Error in exp

its nt wrkng kush..

MVP
MVP

Re: Error in exp

Hi,

Try this

=(count({<def={"Reopen"}>} def) / count({<def={"Open","New","Assigned"}>} TOTAL def) )*100


Hope this helps you.


Regards,

Jagan.

MVP
MVP

Re: Error in exp

Hi Suresh,

Is it Reopen or Reop, correct it accordingly.

Regards,

jagan.

Community Browser