How to Show "Other" in Mapping

[#1]

Hi All,

I would like to ask you about mapping in QV,

I have QVD files that I connect with the txt file, and I mapping  by using an excel file.

But I Can not show item in "CORE_BRAND" because the source is empty, so i wanna show it with "OTHER" if the source is empty.

I enclose the QVD, txt and excel file.

Please help me to show it.

[buzzy996]

try tis,

allow null values from dimension tab and set the belwo properties on dimenion limits tab.

[awhitfield]

HI Ted,

does the QVW have Section Access in it as it fails to open? If so, can you re - upload without@

Andy

[#4]

Hi Shiva,

I'm still not understand, where is "dimenion limits tab" i can found?

[buzzy996]

which version of qlikview ur using?

see tis,

[#6]

I think i use old version of  QView,

[#7]

Hi Andrew,

i have resend the attachment

[buzzy996 · Accepted solution]

yes ur right,u don't have that option with ur version 9.

ok,u can try tis with ur script

if(isnull(urfieldname),'others',uefieldname) as urfieldname

[#9]

how to implement it if I using mapping to excel file?

[buzzy996]

on load statment in ur edit script ,u can try with above syntax!

else share ur excel and qvw,if possible.