Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
ryanwangf
Partner
Partner

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
Specialist
Specialist

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

karunpreet
Creator II
Creator II

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
Partner
Partner
Author

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