topic Re: RE:what wrng in my exp? in QlikView

RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 04:29:46 GMT

hi all,

Sunny T

am caluclating the agebands in weeks,

>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

Re: RE:what wrng in my exp?

sunny_talwar — Tue, 29 Dec 2015 04:32:06 GMT

Are you doing this in a straight table?

Re: RE:what wrng in my exp?

Tue, 29 Dec 2015 04:34:47 GMT

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

Re: RE:what wrng in my exp?

tamilarasu — Tue, 29 Dec 2015 04:39:44 GMT

Try,

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

Re: RE:what wrng in my exp?

PrashantSangle — Tue, 29 Dec 2015 04:42:13 GMT

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

Re: RE:what wrng in my exp?

MayilVahanan — Tue, 29 Dec 2015 04:46:24 GMT

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?

Peter_Cammaert — Tue, 29 Dec 2015 07:55:51 GMT

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)

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 09:48:52 GMT

no sunny...its bar chart

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 09:49:09 GMT

its nt wrkng raj..

Re: RE:what wrng in my exp?

sasikanth — Tue, 29 Dec 2015 09:55:32 GMT

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

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 10:09:36 GMT

thnx sunny...when i select relative...it is shwng 1005...but in chrt also am getting another bar as shwng total label aswell?

Re: RE:what wrng in my exp?

sasikanth — Tue, 29 Dec 2015 10:18:49 GMT

IF possible share your sample file , it would be easy to find out the issue

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 10:24:34 GMT

yes even though it is shwng same

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 10:31:39 GMT

chk attached image shwng reltve selctd..it is shwng same vlues tooand extra legend total also

Re: RE:what wrng in my exp?

sasikanth — Tue, 29 Dec 2015 11:00:40 GMT

if you are also using Defect_aging_days also as a dimension then

try to suppress null values option in dimension tab.

try once

Re: RE:what wrng in my exp?

Chanty4u — Tue, 29 Dec 2015 11:01:43 GMT

yes ihve tried still same it is shwng

Re: RE:what wrng in my exp?

sasikanth — Tue, 29 Dec 2015 11:03:30 GMT

Please do share your qvw