topic Re: Error in exp in QlikView

Error in exp

Chanty4u — Tue, 08 Dec 2015 17:04:55 GMT

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

Re: Error in exp

Tue, 08 Dec 2015 17:15:35 GMT

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

Re: Error in exp

maxgro — Tue, 08 Dec 2015 17:23:56 GMT

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

Re: Error in exp

Chanty4u — Tue, 08 Dec 2015 17:25:54 GMT

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

Re: Error in exp

Chanty4u — Tue, 08 Dec 2015 17:29:29 GMT

it is not wrkng maxgro...

Re: Error in exp

manojkulkarni — Tue, 08 Dec 2015 17:31:32 GMT

can you post some sample data

Re: Error in exp

Kushal_Chawda — Tue, 08 Dec 2015 17:44:25 GMT

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

Re: Error in exp

Chanty4u — Wed, 09 Dec 2015 04:44:35 GMT

its nt wrkng kush..

Re: Error in exp

jagan — Wed, 09 Dec 2015 04:59:05 GMT

Hi,

Try this

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

Hope this helps you.

Regards,

Jagan.

Re: Error in exp

jagan — Wed, 09 Dec 2015 04:59:56 GMT

Hi Suresh,

Is it Reopen or Reop, correct it accordingly.

Regards,

jagan.

Re: Error in exp

Anonymous — Wed, 09 Dec 2015 05:06:33 GMT

Does your expression contains -ve values??

FYI, Pie chart never represent -ve Values..

Re: Error in exp

Chanty4u — Wed, 09 Dec 2015 05:06:48 GMT

yeah..jagan...

this is the final exp

with i hve multiple field names

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

it is shwng Exp ok. bu values no exposing i need in pie chart as %?

Re: Error in exp

Chanty4u — Wed, 09 Dec 2015 05:09:55 GMT

yes..but i dont hve to disply -ve values...

Re: Error in exp

tamilarasu — Wed, 09 Dec 2015 05:10:55 GMT

Hi Suresh,

Can you post your application.?

Re: Error in exp

Anonymous — Wed, 09 Dec 2015 05:12:06 GMT

try this:

=num(

count({<Def_Status={'Reop'}>} DimensionField) //may use Distinct as well

sum(if(ref='Open' or ref='New' or ref='Assigned', 0,1))

,'#')*100

Where do you want to multiply with 100, if it is with sum() then like this

=num(

count({<Def_Status={'Reop'}>} DimensionField) //may use Distinct as well

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

,'#')

Re: Error in exp

Anonymous — Wed, 09 Dec 2015 05:14:13 GMT

Then put condition like in your expression:

=if(sum(sales)>0, sum(sales)) where sum(sales) is your expression

Re: Error in exp

jagan — Wed, 09 Dec 2015 05:16:04 GMT

Hi Suresh,

Give this expression

(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) )

and in number tab select percentage option.

Note: Pie chart won't display negative values, if you have negative values then you have filter it out like below

If((count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ) > 0,

(count({<Def_status={"Reopen"}>} Def_Status) / count({<Def_Status-={"Open","New","Assigned"}>} Def_Status) ))

Hope this helps you.

Regards,

Jagan.