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.

[JandreKillianRIC]

Hi @shrikantdhole 

Not sure about this visual side as I also see the truncation on my side, however - when I download to Excel all the data is there. 

Regards Jandre

[shrikantdhole]

Hi @JandreKillianRIC , Truncation in visual is fine but even when I download the excel I get the truncated data. What I see on the visual is all I am getting in excel.

[JandreKillianRIC]

Hi @shrikantdhole 

Are you using a "normal" table?

How are you exporting this? I right-click the object in Qlik > Download as > Data , Normal without formatting. 

In excel (This is the file I am using in Qlik) 
 

In Qlik - Where the visual cuts off. Len function as a measure

Downloaded in Excel - Opened and tested the length again

All my data is matching - Not losing any information. 

Regards Jandre

[Digvijay_Singh]

I don't see 200 char limit in straight tables. Are you not able to fetch more than 200 char from source JSON file or you observe this in table visual only?

[JandreKillianRIC]

Hi @shrikantdhole 

Another thing to consider is using text(json payload) as TextJson

You might get some characters in the json that Qlik treats as a End of Line character.

Regards Jandre

[shrikantdhole]

In the straight tables in Qliksense I see the limit of 255 characters.pls see screenshot shared by me.

This limit is somehow not reflected in your case.

Wonder why?Is this anything to do with Qliksense version.

[JandreKillianRIC]

Hi @shrikantdhole 

I tested this in Qlik Sense Desktop using Nov 2024 Patch 3. 

What version are you using? 

Have you tried the Text(Response) as TextResponse? 

Regards Jandre

[shrikantdhole]

The Qlik Cloud version I am using is November 2023 patch 10

Tried with Text (Response) but same result

[JandreKillianRIC]

Hi @shrikantdhole 

Can you access the MongoDB and do a length on the field there? I suspect its the DB that limits the field... PS Just a thought. 

Regards Jandre