Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
MVP
MVP

Re: How to load JSON data held in a TXT file please? [Example provided]

You're right Rob. I stumbled over it by chance. If I remember correctly I brought the executable file of Qlik Sense up in a text editor - I think it was Notepad++ to have a look at the list of keywords that might be supported. And surprisingly I found a BNF that showed me the parsing of scripts embedded in the executable. By reading this I discovered the json as a valid format-spec. This was almost a year ago I believe. I confirmed with some other guy that knows the actual code within Qlik Sense that indeed it is supported - in the code.

It has not yet materialized into the documentation. One probable reason for that is that it has a serious limitations when it comes to hierarchical or nested JSON. It doesn't do it. So it is only useful in it's simple use to parse flat JSON-files. It works for both QlikView and Qlik Sense.

No - I didn't find any other undocumented format-spec things apart from json...

-Petter

Community Browser