Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

text variable in set anaylsis

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?

2 Replies
erichshiino
Partner - Master
Partner - Master

You could try:

{'$(=vProdorSub)'}

or

{'$(vProdorSub)'}

Not applicable
Author

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