Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am very new to Qlik.
Can you please confirm below questions regarding excel export option of published dashboard, which is available for user?
I know we can export individual views to excel but how about the below
1. Can we format the data we are exporting to excel in certain format? Like deleting, adding or highlighting or limiting the data?
2. Can we export the entire data set of the dashboard to excel from a dashboard?
3. This is not relevant to export option, but asking here. Can we add comments on dashboard anywhere. Basically if user wanted to add some notes of their analysis, is it possible?
Please refer any video link if available explaining all export options, so that i can see visually how it looks.
Hello @Amala
as i think your are talkign about Qlik cloud:
What i normaly do is to create a details sheets, with lots of filters and a table with all fields, so user can filter and then export filtered data to excel.
you can also have a look on tabular reporting add-in
https://www.youtube.com/watch?v=rX--26_6Eqw
also, you can check Mail&Deploy product to create & manage reports
about comments, please check
https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Notes/notes-using.htm
hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button!
Adding to the previous answer :
1. You can modify the table you need before the export :
In the above screenshot I first load the data normally before loading it with conditions for the export. So using this you can modify field name or content, filter table... To alter an existing excel file, you can load it into Qlik, concatenate or filter the table before re exporting it.
Note that following the Store function docu, it seems impossible to export directly in xlsx. See : Store | Aide QlikView
It can be done from the dashboard however. Rigth-clicking on a graph, you can export its data into Pdf, jpg or xlsx.
Best regards,
Maxim Perolle
Hi Maxim Perolle,
Thank for the reply. I am sure that we can export the data into excel from individual graphs.
Is it possible to export the entire dashboard data into excel.
In the below screen shot, we have two options on right top corner, Search button and export option
Can you please confirm what are the options available in that export option.
I can't find those two button anywhere on Qlik Sense SaaS or Desktop.
However if you really need to, you can explore Qlik Automation wich allows you to do that.
Don't hesitate to ask me question if you need more help
Best regards,
Perolle Maxim
Thank you Maxim.
Is there any way to export entire data to excel of published dashboard ???