Skip to main content

GeoAnalytics

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ryanwangf
Partner - Contributor III
Partner - Contributor III

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 - Contributor III
Partner - Contributor III
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