Need Extension/ Solution to Download My Table Data in the Sheet

[Olivia_Rose]

Hi experts,

     I have created a table in my sheet let's call it "Table_X". I want to create an button, by clicking that button the user can download that "Table_X" as .csv file into their device. 

1.How can I do it? 

2. Does vizlib button extension can do it? if "Yes", how?

Please the below image for your reference. I would be much obliged if you can help me.!😊

[Ravi1212 · Accepted solution]

Hello @Olivia_Rose ,

You can download it by two simple ways 

 Using Qlik Sense Native Export Feature ==>

Qlik Sense provides a built-in way to export tables.
Users can manually export tables by clicking the three dots (•••) in the top-right corner of a table and selecting "Export data".

However, if you want a dedicated button for this, continue below.

2. Using the Vizlib Button to Export Table_X as CSV
Vizlib Button Extension allows you to trigger an export when clicked. Follow these steps:

Step 1: Add the Vizlib Button
Open your Qlik Sense sheet.
Add the Vizlib Button extension from the Custom Objects panel.

Step 2: Configure the Button Settings
In the Vizlib Button settings, go to Actions & Navigation.
Click Add Action → Select "Export Data".

Step 3: Configure Export Data Action
Object ID: Enter the ID of Table_X (You can find the object ID in the table properties > Developer > Object ID).
File Format: Choose CSV.
File Name: Set a custom name, e.g., "Table_X_Export.csv".
Include Title: Yes/No (based on preference).
Include Selection State: Optional.
Open in Browser / Download Directly: Choose Download Directly.

Step 4: Save and Test
Click Apply Changes and test the button.
When clicked, the table should automatically download as a CSV file.

Let me know if you face any issues or you need any further information  😊

[Olivia_Rose · Accepted solution]

@Ravi1212 ,

                 Thank you.😊 

As well as I found an extension that also do the work easily. I have attached that extension to anyone to whom will be useful in the future.😊

[Nithin29]

Hi,

Same scenario, i have created a vizlib button to download my table data. I have a more number of rows which i cant download, i want to download with limitations. I tried limitation option under dimensions , if i select fixed number i can able to download either top or bottom based on the measure values. But irrespective of any sorting order i want to download only the first few rows(ex 100). I have also created a variable input which helps the users to enter their own values and download.

[Olivia_Rose]

Hi @Nithin29 

• To download the "first N rows" ignoring sorting, you'll need to apply a calculated dimension or a ranking expression that designates the natural row order and then limit by that.

• Use a variable input (e.g., vRowLimit) control so users can dynamically enter the number of rows to download.(like 100)

• Create an expression in your table, such as RowNo() or a rank function based on your natural order (e.g., an ID field or load order), then use it to filter rows up to the user-input variable.e.g. =If(RowNo(Total) <= $(vRowLimit), YourDimensionField)
  This expression filters the table dimension to only the first N rows defined by the variable.

• In your Vizlib button settings for the download:

  • Use this calculated dimension or apply a limitation that respects the variable value to restrict rows.

  • Alternatively, set a dimension limitation where the "Fixed Number" is linked to the variable $(vRowLimit).

• When users input a number in vRowLimit, the table and downloaded data will dynamically reflect only those rows starting from the first row regardless of sorting.

• e.g.=RowNo(Total) <= $(vRowLimit) //expression for dimension limitation
  e.g. =If(RowNo(Total) <= $(vRowLimit), DimensionField) //Or as a dimension:

• This forces the download to include only up to the number of rows the user defines in the variable, ignoring sorting order. So this method is commonly used to limit large downloads and provide user-flexible row limits in Qlik Sense with Vizlib's functionalities.

  If your data has a specific order key (like an ID), you might rank by that field instead of RowNo() for more control. You can use set analysis or if condition in the download or dimension limitation expression referencing the variable for dynamic filtering. 😊

  Hope this will help to your development.! 😊