Discussion Board for collaboration on QlikView Layout & Visualizations.
I have one requirement,
Field name -- ShowRoom it has values such as India,
I need not show the values as is original..
instead of India it should show as SRoom1,
China as SRoom2....etc
how to change the value name in a field?
please help me to solve!
Also in one field Product it has some values with null values...i have to show null value as Others instead of - in chart. Please help me for this issue also?
Go to Solution.
For this you hv to use mapping function
LOAD * INLINE [
Map NewName using CountryNamesMap;
for other country u do it like this
try this in load script
You can use the below mentioned script at load time.
if(wildmatch(ShowRoom,'',' ') or isnull(ShowRoom),'NULL')))
Hope this will help you.
thanks for your reply...but i have 26 showrooms...so for all showrooms, whether i have to write in the script?
Hi nilesh ganrude,
Thanks for ur reply
Request you to please mark the post as Correct ans or Helpfull Ans.
THANKS... THIS INLINE LOAD WORKS