topic Displaying Raw Data for Export in QlikSense in App Development

Displaying Raw Data for Export in QlikSense

remedibi — Tue, 20 Sep 2016 18:29:41 GMT

Hey everyone.

I have a business user who we want to automate a report for. He typically puts in a request for a raw data file in excel that he then pivots and does a number of things to. We're working with him to recreate a lot in Qlik, but the nature of the report is such that a raw pull of about a years worth of data is run overnight, and then when the report is opened, he can select how he wants to slice and dice it to see the data. It's a large raw data set, but that's because there are a lot of possible options to slice by.

My question is this...how can I give him the option to export data (after he slices) to excel without the system just bogging down from trying to show the raw, pre filtered data? Right now the raw data page I created just tries to load everything before you can even apply a filter (see image below) and doesn't finish. I want no data to show until he selects what he wants from the drop downs above, so he can then export to excel. Maybe a filter exists, you press a button, and it displays? Does anyone know if that is possible or something similar?

Re: Displaying Raw Data for Export in QlikSense

Gysbert_Wassenaar — Wed, 21 Sep 2016 08:56:33 GMT

You can add a calculation condition to a chart.

That allows you to prevent the chart from rendering until some selections have been made. Perhaps an expression like =sum(aggr(1, DimA, DimB, DimC, ..., DimN)) < 50000. Replace DimA, DimB, DimC, ..., DimN with the dimensions of the chart.

Re: Displaying Raw Data for Export in QlikSense

remedibi — Wed, 21 Sep 2016 14:17:20 GMT

I'm still having issues with it taking forever to load, something the executives won't bother themselves with.

Maybe I can reframe the question - is it possible to allow a user to filter and then export data without it having to load on the screen? I want the end user to play with the visualizations I'm creating after they filter to what they want to see, but is there any way for them to then take the underlying filtered data and export to excel?

Re: Displaying Raw Data for Export in QlikSense

Gysbert_Wassenaar — Wed, 21 Sep 2016 16:20:33 GMT

Uhm... did you even try my suggestion?

With an calculation condition the chart will not render until the condition is met. When the condition is met and the chart is rendered it's possible to export the data by right clicking the chart and choosing the Export data option.

Re: Displaying Raw Data for Export in QlikSense

remedibi — Wed, 21 Sep 2016 16:22:45 GMT

I did. Sorry, first time I tried it I did it incorrectly. This fixed the issue. I was able to have the chart only display if less than 3 months of data is selected (but the remainder of the report can use more than 3 months.) Appreciate the help.