Reset dimension(QlikView)

[ryanwangf]

Hi Guys,

There is a requirement about dimension, for example:

if (dimension1='abc','link-abc',dimension1).

"link-abc" is from excel, so I want maintain the "link-abc" by excel, can I achieve this requirement?

Many Thanks

Ryan Wang

[Anonymous]

Can you please be more specific, with a screenshot if possible.

[Anonymous]

Hi Ryan,

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.

Regards

Karunpreet

[ryanwangf]

Hi Karunpreet,

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?

Many Thanks

Ryan