Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

ryanwangf
New Contributor II

Reset dimension(QlikView)

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

3 Replies
laddu_927
Valued Contributor

Re: Reset dimension(QlikView)

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

karunpreet
Contributor

Re: Reset dimension(QlikView)

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
New Contributor II

Re: Reset dimension(QlikView)

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

1.png2.png3.png

Community Browser