Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Chanty4u
MVP
MVP

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

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

maxgro
MVP
MVP

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

Chanty4u
MVP
MVP
Author

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

Chanty4u
MVP
MVP
Author

it is not wrkng maxgro...

manojkulkarni
Partner - Specialist II
Partner - Specialist II

can you post some sample data

Kushal_Chawda

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

Chanty4u
MVP
MVP
Author

its nt wrkng kush..

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this

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


Hope this helps you.


Regards,

Jagan.

jagan
Luminary Alumni
Luminary Alumni

Hi Suresh,

Is it Reopen or Reop, correct it accordingly.

Regards,

jagan.