Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to Show "Other" in Mapping

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.

Tags (2)
1 Solution

Accepted Solutions
buzzy996
Honored Contributor II

Re: How to Show "Other" in Mapping

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

12 Replies
buzzy996
Honored Contributor II

Re: How to Show "Other" in Mapping

try tis,

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

others.PNG

awhitfield
Esteemed Contributor

Re: How to Show "Other" in Mapping

HI Ted,

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

Andy

Not applicable

Re: How to Show "Other" in Mapping

Hi Shiva,

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

buzzy996
Honored Contributor II

Re: How to Show "Other" in Mapping

which version of qlikview ur using?

see tis,

dl.PNG

Not applicable

Re: How to Show "Other" in Mapping

I think i use old version of  QView, QVVersion.png

Not applicable

Re: How to Show "Other" in Mapping

Hi Andrew,

i have resend the attachment

buzzy996
Honored Contributor II

Re: How to Show "Other" in Mapping

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

Not applicable

Re: How to Show "Other" in Mapping

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

buzzy996
Honored Contributor II

Re: How to Show "Other" in Mapping

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

else share ur excel and qvw,if possible.

Community Browser