Data more than 1 million in qliksense

[Anonymous]

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.

[YoussefBelloum]

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

export on excel on the front end ?

[Anonymous]

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

[YoussefBelloum]

read this:

Export to Excel - limitation in number of rows

[nsetty]

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