topic $ dollar Sign when Loading excel in Qlikview in QlikView

$ dollar Sign when Loading excel in Qlikview

pradeep92 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am just loading the sheets from excel in qlikview. But when Loading it , I am getting $ sign along with the table name. Can I know what is the reason ?

P.S: When i loaded another excel into qlikview, I didnt get table$, I just got load * ... from data ; and not as data$;

Re: $ dollar Sign when Loading excel in Qlikview

Anonymous — Wed, 11 Oct 2017 08:34:57 GMT

when the Excel file is defined as xls (97-2003 Workbook) you may get the $ sign at end of name

when the Excel file is defined as xlsx (Excel workbook) you donot get the $ sign

I just made a few test and each test confirms it

Re: $ dollar Sign when Loading excel in Qlikview

pradeep92 — Wed, 11 Oct 2017 09:35:21 GMT

Thanks a lot !