topic Re: Evaluate String as Expression in QlikView

Evaluate String as Expression

bruno_m_santos — Mon, 08 Jul 2013 09:46:14 GMT

Good morning,

I'm trying to evaluate a string in a Pivot Table as an Expression, but it's not working...

(len(Expression1)<>0, Expression1, Sum($(vSetMTD) #Amount))

Expression1:

(aggr( sum(TOTAL $(vSetMTD_2Intersect)* <[Report Name]={'DRBI'},[Report LineNr]={'A25'} >} #Amount),[Report LineNr])*-0.30)

If I copy the cell value and paste as an Exporession, it works.

Could you help me please.

Thanks

Bruno

Gysbert_Wassenaar — Mon, 08 Jul 2013 09:53:45 GMT

Maybe like this: if(len(Expression1)<>0, $(Expression1), Sum($(vSetMTD) #Amount))

Edit: it would help if you posted a sample document

bruno_m_santos — Mon, 08 Jul 2013 09:58:31 GMT

Returns nothing.

Bruno

anandathome — Mon, 08 Jul 2013 10:20:47 GMT

Hi Bruno,

I am not sure where you have stored the Expression1.

My suggestion would be (if you have not done already)

1. Create Expression1 as variable in Load script like

SET Expression1='(aggr( sum(TOTAL $(vSetMTD_2Intersect)* <[Report Name]={'DRBI'},[Report LineNr]={'A25'} >} Amount),[Report LineNr])*-0.30)'

2. Then your expression should be

if(len(Expression1)<>0, $(Expression1), Sum($(vSetMTD) #Amount))

-Anand.

bruno_m_santos — Mon, 08 Jul 2013 10:44:06 GMT

Hi Anand

It’s stored at Report Line Level.

I pretend to evaluate to each line, if an custom formula exists, if not, I want to use an general formula)

Thanks

Bruno