topic Straight table with restriction and excel export in QlikView

Straight table with restriction and excel export

Wed, 29 Sep 2010 10:24:58 GMT

Hi all,

I have a straight table that only shows 1000 firsts lines of a selection.

I want users could export all lines from their selection to Excel even thought only 1000 are viewable.

Actually, the export works only on what is visible.

Is there a solution?

Straight table with restriction and excel export

sunil2288 — Wed, 29 Sep 2010 10:48:33 GMT

Hi Ptitcon,

There is option of export to Excel sheet what is viewing in the application.

You have limited the rows to 1000 for showing purpose .How it could be possible that the value which is not showing will be exported..

So You can only export the data that is present in your object in the sheet not in the table.

Regards

Sunil

Straight table with restriction and excel export

Wed, 29 Sep 2010 12:57:04 GMT

Thanks you!

I would like to show only 1000 lines in the aim of deal with memory. The straight table that the users want is too big. And they like work with Excel. I know that the best solution is to analyze datas directly on Qv, but they prefer export table to Excel.

I hoped a solution exists to deal with this big table by limiting visible rows but export all possible rows.

Straight table with restriction and excel export

Thu, 30 Sep 2010 14:36:39 GMT

I found a solution!

First, I have limited viewables lines in tables by adding the condition belong :

if( sum(if(ID=null(),0,1))<1000,1,0)

So, users couldn't see more lines if they don't specify search.

Then, I had an export button wich permits export some fields to csv file without restriction (only the selection restriction).
Datas aren't viewable but could be export.
If a selection make 2000 lines over 50 000, users see 0 lines but could export 2000.

My point of view : There is no interest to export the unviewables datas. But my users want it.
Later they will realize that theirs Excel analysis could be perform on Qv.