topic Re: Can it work? in QlikView

Can it work?

Wed, 03 Oct 2012 20:13:02 GMT

I need to make this expression work. Any body has any idea?

SUM({$<TEXT(CUSTOMER_NUMBER&DIVISION)={'13715DNE'}>} DOLLAR)

CUSTOMER_NUMBER = 13715

DIVISION=DNE

Thanks,

Nima

Re: Can it work?

m_woolf — Wed, 03 Oct 2012 20:21:24 GMT

Concatenate CUSTOMER_NUMBER&DIVISION in script as NewField,

then use NewField in set analysis?

Re: Can it work?

Wed, 03 Oct 2012 20:24:19 GMT

I don't want to change any thing in script. that's why I want to do it in expression.

Re: Can it work?

Wed, 03 Oct 2012 20:29:42 GMT

It would be easiest to do it in the script, but you could use an IF statement if you needed it as an expression. If(CUSTOMER_NUMBER & DIVISION='13715DNE',sum(Dollars) and then suppress nulls.

Re: Can it work?

Wed, 03 Oct 2012 20:30:03 GMT

Sorry add one more ) at the end

Re: Can it work?

Wed, 03 Oct 2012 20:34:54 GMT

The problem is that there is many of them and I want to compare all of them. That's why I used {}.

Re: Can it work?

Wed, 03 Oct 2012 20:38:00 GMT

Do you have a sample file of what you are looking for?

Re: Can it work?

rwunderlich — Thu, 04 Oct 2012 04:55:10 GMT

You can't use a function on the left side of the "=". So do it as two modifers like this:

SUM({$<CUSTOMER_NUMBER={13715}, DIVISION={DNE}>} DOLLAR)

-Rob

Re: Can it work?

Thu, 04 Oct 2012 20:46:39 GMT

I had no choice . I had to do it in script.

Thanks to all