Discussion Board for collaboration regarding Qlik GeoAnalytics.
There is a requirement about dimension, for example:
"link-abc" is from excel, so I want maintain the "link-abc" by excel, can I achieve this requirement?
Can you please be more specific, with a screenshot if possible.
As per my understanding of your requirement, you can use the below expression
if ( Match(Dimension1, 'abc'), 'link-abc', Dimension1) AS NewDimension
or else if you want 'link-abc' to be coming from excel, then you can store this value in a variable (supposedly: vExcelLink) and change the expression to ,
if ( Match(Dimension1, 'abc'), '$(vExcelLink)', Dimension1) AS NewDimension
Please do let me know for any concerns on the same.
there is a problem, I did as what you said, created a variable, but when I change the excel and reload the data, it will prompt "can't find the dimension", is there any idea to solve this problem?