Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
You'll likely want to create a Mapping table to translate the values.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
@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 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.
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.
You'll likely want to create a Mapping table to translate the values.
-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com
@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
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!
Yes, this worked! Thank you!