topic text variable in set anaylsis in QlikView

text variable in set anaylsis

Tue, 21 Jun 2011 20:36:25 GMT

Sum ({<NumFYQTR={$(=Max(NumFYQTR,1))},[Work Day in FQ]={"<=$(=VMaxPOSWDay)"},[Subscription Indicator]={$(=vProdorSub)},[Sales Type] ={"Commercial"}> }[TOTAL BOOKED ($)])

The variable is assigned by use of a button action to Non-Subscription or Subscription

But once I put in this variable instead of "Non-Subscription", it stops working.

I tried with and without the quotations adn the button is assigning the right value.

The Subscription button works for the variable, not the Non-Subscription button

is this due to the "-" in the text?

text variable in set anaylsis

erichshiino — Tue, 21 Jun 2011 20:38:57 GMT

You could try:

{'$(=vProdorSub)'}

{'$(vProdorSub)'}

text variable in set anaylsis

Tue, 21 Jun 2011 20:44:36 GMT

Wow you are quick and thank you, top one worked perfectly. A amzing how these tiny little changes can make or break