Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Accepted Solutions
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.
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.
