Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Data more than 1 million in qliksense

How can we export data in qliksense more than 1 million,As in my app has more than 1 million data ,and whenever I tried to export it,it says your dataset was too large and has been trucated.Is there any way so that data can be stored.

4 Replies
YoussefBelloum
Champion
Champion

to which format and how do you want to export 1 million rows ?

export on excel on the front end ?

Anonymous
Not applicable
Author

When I export ,it is exported in excel  .In my app ,there is more than 1 million row ,so what I wanted is that ,1 million data come in sheet 1 in excel rest data will come in sheet 2 of a excel without trucatet

nsetty
Partner - Creator II
Partner - Creator II

can you try storing data to text file?

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/...

store mytable into myfile.txt (txt);


Thanks