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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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