Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fdelacal
Specialist
Specialist

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

Can you attach your sample file

clisboa_noesis
Partner - Creator
Partner - Creator

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
Specialist
Specialist
Author

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
Partner - Specialist
Partner - Specialist

Hi, maybe there is a missing braket?

num(

     (

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

          if(STATUSBOOK<5,GSP_BOOKING.SESSIONDURATION_XOR

              )    

          )*24

     )

Not applicable

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

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

fdelacal
Specialist
Specialist
Author

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
Partner - Creator III
Partner - Creator III

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