Discussion Board for collaboration on QlikView Scripting.
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.
Go to 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
allow null values from dimension tab and set the belwo properties on dimenion limits tab.
does the QVW have Section Access in it as it fails to open? If so, can you re - upload without@
I'm still not understand, where is "dimenion limits tab" i can found?
which version of qlikview ur using?
I think i use old version of QView,
i have resend the attachment
how to implement it if I using mapping to excel file?
on load statment in ur edit script ,u can try with above syntax!
else share ur excel and qvw,if possible.