HELP WITH FORMULA

[fdelacal]

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

[#2]

Can you attach your sample file

[clisboa_noesis]

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

[fdelacal]

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.

[bbi_mba_76]

Hi, maybe there is a missing braket?

num(

     (

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

          if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR

              )    

          )*24

     )

[#6]

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%')

[#7]

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

[fdelacal]

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

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

regards

[jchoucq]

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