RE:what wrng in my exp?

[Chanty4u]

hi all,

Sunny T

am caluclating the agebands in weeks,

like

>3days

<=1day

<=2Days

<=3Days

my exps

=(Count({<Defect_Aging_Days={'<=1' ,'<=2','<=3','>3'}>}  Def_ID)/count(TOTAL Def_ID))*100

it is shwng ok.. but the thing where am shwng dese values in'' %    ''  it is nt gvng 100%...it total count gvng only 92%lik dat

why it is any idea

thanks

Suresh 

[sunny_talwar]

Are you doing this in a straight table?

[#3]

Have you checked for the Null or blank values...

[tamilarasu]

Try,

=Count({<Defect_Aging_Days={'<=1' ,'<=2','<=3','>3'}>}  Def_ID) / count(Def_ID)*100

[PrashantSangle]

Hi,

Is there any possibilty some of Def_ID come in more than 1 bucket or not in any bucket.

test your expression in individual text objet.

check what was the output of this expression in one text object

Count({<Defect_Aging_Days={'<=1' ,'<=2','<=3','>3'}>}  Def_ID

and in another object.

count(TOTAL Def_ID)

Regards

[MayilVahanan]

Hi

Please answer below questions

Both Defect_Aging_Days, Def_ID are available in same table?

If so, all Def_ID has Defect_Aging_Days values?

[Peter_Cammaert]

Are you sure that your Defect_Aging_Days category labels aren't treated as search strings in your set analysis, '>3' meaning that Defect_Aging_Days should be larger than 3? I know that HIC wrote that single quotes should indicate a literal, but that they still don't (he called this a "bug", see QlikView Quoteology - 8th comment)

[Chanty4u]

no sunny...its bar chart

[Chanty4u]

its nt wrkng  raj..

[sasikanth]

HI,

Instead you can select relative option in Expression tab which will also serves the same

Just write your expression and check relative option

If you use Count(Total) option there may be a chance of existing other ranges than specified ranges, that might be the reason that you didnt get 100%

Try once