Discussion board where members can get started with QlikView.
I have a case where I want to add a button with "Select in Field".
I have the fields:
And I want to create a button that filters on all CustomerID where CustomerSale is bigger than CustomerBudget
I thought I could use CustomerID as Field, and =(CustomerSale > CustomerBudget) as Search String, but no go.
Go to Solution.
There's a little specific for the search string syntax in an action, try
='=CustomerSale > CustomerBudget'
Thanks for the try, but it doesn't seem to work (Expression OK, but nothing happens).
Can you post some details about your data model (how are the three fields related to each other)?
Do you have several CustomerSale records per ID?
='=sum(CustomerSale) > sum(CustomerBudget)'
(as is, including the single quotes an the preceding equal sign, as search expression)
I'm sorry, your suggestion worked, but I'd chosen "Select in Field" instead of "Toogle Select".
Thanks, it works perfect now!