Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
While undergoing development, there are changes to the data model that requires me make changes to a large number of expressions.
I have about 20 straight tables, each with about 40 dimensions/measures.
The change is something like changing TABLE_A.fieldA to TABLE_B.fieldA but I need to make this change one by one in all the dimensions/measures expression. I have not made the tables prefix a variable either.
Question 1: Is there a faster way to do this, like how we can find+replace in the Load Script?
Question 2: Even if I do make all the changes, in the event that I miss out any changes, I understand that QlikSense does not have an explicit error message to inform me that my expression is invalid. Is there any way, even an external application that can help to do this check?
Hi,
In the current situation, you can not do much.
But if you would have used the master items then it would have been much easy for you. All you would have needed to do is change master item expression and it will change all charts and graphs where you have used it.