Limitation in QlikSense table objects while showing Text Data from JSON file

[shrikantdhole]

We have imported the Json File format Data from MongoDB to Qliksene.

We are showing this data in Table Visual.

However we are observing that the characters more than around 200 are getting truncated in table visual due to character limit.

We want to make sure that entire cell data should be viewed and downloaded in QlikSense.

As JSON file has cells where the characters are around 50K or more. Need solution to get rid of this text character limit in Qlik Sense Table visual.

[shrikantdhole]

Checked Mongodb it has the entire data this seems qlik product text character limitation.

Is there way to resolve this like may be using some free or paid extension to view complete data?

[JandreKillianRIC]

Hi @shrikantdhole 

I don't think a extension is going to help here. 

I am not getting this limitation anywhere. 

Are you running Qlik Sense Enterprise Nov 2023. Im running a older version, Let me test it on here.

Regards Jandre

[JandreKillianRIC · Accepted solution]

Hi @shrikantdhole 
I think I found the issue....Because this worked on my Feb 2023 release.  

On the Connector, There is a setting for the length of the field. (This took me quite some time to fix but I am determined to solving this issue) 

Here is the documentation for the MongoDB Connection. 

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Mongo/...

Let me know! 

Regards Jandre

[diegozecchini]

Great! it wasn't easy to find..

[shrikantdhole]

This solution indeed solve my problem.

Thanks a Ton!

[shrikantdhole]

Spoiler

Qliksense table visual Excel download has limitations of characters

@JandreKillianRIC  The previous suggestion did solve my problem, really appreciate your inputs.

Now my Qliksense table visual shows the data However when I download excel or CSV there is still a restriction in the downloaded file.

Is there a way I can download entire data in Excel or CSV which is there in the table 

[shrikantdhole]

As I can see this attached screenshot warning message that tells there is a limit of 16384 characters to download the excel data from Qliksense