Qlik Community

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
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