topic Expression with Alternate State not working in QlikView

Expression with Alternate State not working

Wed, 05 Mar 2014 10:03:33 GMT

Hi,

In my Straight table chart I am using the following formula in the expression:

num(sum({$<Customer = p({[AltState1]}Customer)- p({[AltState2]} Customer)>}Sales),'$#,##0')

where I am trying to find out list of Customers slected in Alternate State AltState1 and not there in alternate state 2 AltState2.

and the Straight Table is in AltState1.

Whenever selection is made in AltState2 the values are not reflected.

Dimension used is: Customer

Thanks in advance!!

Regards,

Pooja

tresB — Wed, 05 Mar 2014 10:23:08 GMT

Try this:

num(sum({<Customer = [AltState1]::Customer>- <Customer=[AltState2]::Customer>}Sales),'$#,##0')

Wed, 05 Mar 2014 10:28:04 GMT

Thank you for your suggestion..

But this expression doesn't seem to work for me..

tresB — Wed, 05 Mar 2014 10:35:51 GMT

It's working with me. Could you please share your sample app?

jagan — Wed, 05 Mar 2014 10:50:02 GMT

Hi,

Try like this

=num(sum({[AltState1]<Customer -= P({<Customer=[AltState2]::Customer>})>} Sales),'$#,##0')

Regards,

Jagan.

Wed, 05 Mar 2014 11:21:21 GMT

Hi Jagan,

Thank You for your suggestion.

The problem I faced while using your expression was it gave an error at the p().

Regards,

Pooja

jagan — Wed, 05 Mar 2014 11:27:45 GMT

Hi,

I will show error but it works. It is showing because -=.

Regards,

Jagan.

Wed, 05 Mar 2014 12:20:04 GMT

PFA, Sample app.

Regards,

Pooja