Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

SubField() function

Hi,

This function just doesnt seem to work. I have tried loading the data with the lib path and disabling the standard mode.

Any help will be greatly appreciated!

-ThanksScreenshot (28).pngScreenshot (29).png

6 Replies
Highlighted

I don't think this has to do with the SubField function because you are erroring out at the top of the table for ProductID... I think you will see the same error if you don't add SubField... it seems to be something related to the location of the file

Highlighted
Specialist II
Specialist II

Your file is missing ProductID field. Error is not for Subfield function. Please check

Highlighted
Contributor II
Contributor II

Thanks for your response.

But my access table does contain ProductID field!

I tried loading it again, but it doesnt seem to recognize the fields!

PFAScreenshot (30).pngScreenshot (31).png

Highlighted
Contributor II
Contributor II

PFB!!

-Thanks,

Highlighted
Specialist II
Specialist II

Check spelling/case for the field. May be some typos

Probably path issue...

Is there a reason for doing it separately. Try putting it in the first load and comment out everything related to path to see if path is causing it to fail.

Highlighted
Contributor II
Contributor II

Any leads on this?