Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

fdelacal
Valued Contributor

HELP WITH FORMULA

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

8 Replies
Not applicable

Re: HELP WITH FORMULA

Can you attach your sample file

Highlighted
Partner
Partner

Re: HELP WITH FORMULA

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
Valued Contributor

Re: HELP WITH FORMULA

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.

Partner
Partner

Re: HELP WITH FORMULA

Hi, maybe there is a missing braket?

num(

     (

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

          if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR

              )    

          )*24

     )

Not applicable

Re: HELP WITH FORMULA

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

Not applicable

Re: HELP WITH FORMULA

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

fdelacal
Valued Contributor

Re: HELP WITH FORMULA

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

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

regards

Partner
Partner

Re: HELP WITH FORMULA

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