Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am fairly new to Qlikview, so I am unsure about this. I have a text object with the following
='Current Ticket Assigned to Tech Support: ' & Count({$<[Status]={'Open','Working','Pending','Pending Third Party','Hold'}, Group={'Technical Support - Issues'}>}[Ticket Id])
I want this field to stay static. Currently if you click on other objects (all from the same data source) that number changes. I only want it to change when the script is reloaded to bring in the new results.
Change the $ in the set analysis to a 1. The 1 tells it to ignore selections in any of your fields:
='Current Ticket Assigned to Tech Support: ' & Count({1<[Status]={'Open','Working','Pending','Pending Third Party','Hold'}, Group={'Technical Support - Issues'}>}[Ticket Id])
Change the $ in the set analysis to a 1. The 1 tells it to ignore selections in any of your fields:
='Current Ticket Assigned to Tech Support: ' & Count({1<[Status]={'Open','Working','Pending','Pending Third Party','Hold'}, Group={'Technical Support - Issues'}>}[Ticket Id])