Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

sureshqv
Esteemed Contributor III

RE:what wrng in my exp?

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 

16 Replies

Re: RE:what wrng in my exp?

Are you doing this in a straight table?

Not applicable

Re: RE:what wrng in my exp?

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

Re: RE:what wrng in my exp?

Try,


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

Re: RE:what wrng in my exp?

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

Regards,
Prashant Sangle

Re: RE:what wrng in my exp?

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?

Re: RE:what wrng in my exp?

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)

sureshqv
Esteemed Contributor III

Re: RE:what wrng in my exp?

no sunny...its bar chart

sureshqv
Esteemed Contributor III

Re: RE:what wrng in my exp?

its nt wrkng  raj..

sasikanth
Valued Contributor III

Re: RE:what wrng in my exp?

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

Community Browser