topic Re: HELP WITH FORMULA in QlikView

HELP WITH FORMULA

fdelacal — Fri, 11 Oct 2013 11:43:43 GMT

Hi i have a problem.

The formula works good in a text objet but not in pivot table. i atach an image, so i need to know why the colors dissapear.

Regards

Re: HELP WITH FORMULA

Fri, 11 Oct 2013 11:47:34 GMT

Can you attach your sample file

Re: HELP WITH FORMULA

clisboa_noesis — Fri, 11 Oct 2013 11:47:40 GMT

Hi,

The syntax color disapears because of the STAFFID -= {..}

It's a bug in qlikview, i usually use the form STAFFID = {"*"}-{...} which doesnt cause this issue.

Regards,

Carlos

Re: HELP WITH FORMULA

fdelacal — Fri, 11 Oct 2013 12:10:48 GMT

i can't atach is so heavy

in the table i use.

dimension = valueloop(1,9)

expresion =

last week =

9 expresion... the problem is in prudictive %

Pick(ValueLoop(1,9),

expresion 1,

expresion 2,

expresion 3,

num((sum({$<STAFFID-= {"0000*"}>}if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR))*24)

(sum(aggr(if ( not isnull((GSP_STAFFTIME.ETIME -GSP_STAFFTIME.STIME)),sum(GSP_STAFFTIME.ETIME -GSP_STAFFTIME.STIME),0),STAFFID,STARTDATE))*24),FormatoNumPorcen)

expresion 5,

expresion 6,

expresion 7,

expresion 8,

expresion 9)

hope that see more better.

Re: HELP WITH FORMULA

bbi_mba_76 — Fri, 11 Oct 2013 12:18:14 GMT

Hi, maybe there is a missing braket?

num(

(

sum({$<STAFFID-= {"0000*"}>}

if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR

)

)*24

)

Re: HELP WITH FORMULA

Fri, 11 Oct 2013 12:19:32 GMT

try this

instead of this

num((sum({$<STAFFID-= {"0000*"}>}if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR))*24) ,

try this hope it will help you

num(if(wildmatch(STAFFID,'0000*')=0 or STATUSBOOK<5,sum(GSP_BOOKING.SESSIONDURATION_XOR)*24),'##.00%')

Re: HELP WITH FORMULA

Fri, 11 Oct 2013 12:24:43 GMT

While usin Set analysis in your given expression yuo are usin Double Quotes .. STAFFID={"0000*"} . Try Using Single Quote e.g. STAFFID={'0000*'}

Re: HELP WITH FORMULA

fdelacal — Fri, 11 Oct 2013 13:13:56 GMT

The formula is OK.. it give me a result,

the problem is that don´t show this "result" in the table!! see image

regards

Re: HELP WITH FORMULA

jchoucq — Fri, 11 Oct 2013 13:24:17 GMT

Hi,

can you try using TOTAL order in your expression

num((sum({$<STAFFID-= {"0000*"}>} TOTAL if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR))*24)

Regards,

Johann