Master Dimension Expression Change

[ColtE8]

Hello!

I want to be able to create what I believe should be a master dimension. I have a "Reference" field but based on that field, you can't always determine what is going on within that reference. For example:

The reference pulled from the data might be LFN-P0064 but we need to know that LFN-P0064 is really Revenue. So when I pull the "Reference" into a table, instead of showing LFN-P0064, I would like to see Revenue.

Or

APD-J0586 is Procurement and instead of showing APD-J0586 I need to see Procurement.

I have a massive list of these references though so I thought creating a master dimension would be easier? Please advise or let me know if this doesn't make sense!

[Anil_Babu_Samineni]

@ColtE8 I didn't understand really the content, sorry for that.

Mostly you are looking Possible (P()) functions to know the revenue from another field - This is just guess, Can you please explain with data. 

[ColtE8]

Sorry! No it's not trying to get revenue or any numerical value from anything.

Essentially, the data that I have to work with is awful. I am basically trying to create my own field. This field will read a reference column and return the name that I give it.

So the reference column could show LFN-P0064 but I want it to instead show "Revenue". These are all made up examples because I am not free to show any actual data.

[rwunderlich · Accepted solution]

You'll likely want to create a Mapping table to translate the values. 

https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPref...

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[Aditya_Chitale · Accepted solution]

@ColtE8 ,

You don't necessarily need to create a master dimension for that. Instead you will have to maintain a master file containing mapping column (original value column & addressed value column).

Then you can join this file with your fact table or use Applymap() to map addressed values with og values.

Regards,

Aditya

[ColtE8]

This is great! I didn't even realize this was possible but this is so much easier. Learning something new every day since I started using Qlik. Thank you!

[ColtE8]

Yes, this worked! Thank you!