4 Replies Latest reply: Jun 12, 2017 3:10 PM by William Christensen RSS

    Create sheet that contains all data behind an application?

    William Christensen

      I have an application that I would like to export all source data including information from import scripts as well as fields calculated in application variables. I can create a table and add each field / variable as a dimension but since I have hundreds of fields I was hoping there might be an easier way. The purpose is primarily to show end users why a given result is not in visualization. For example, if we have an application that indicates “the first sale of the day” and we filter on the “top sales person”, why there are no sales showing for the current months “first sale of the day” chart? In this example, the top sales person likely works evenings and therefor will likely never have the first sale of the day. This scenario occurs over a large range of potential fields so I would like to be able to quickly export all data to excel so I can answer these questions on the fly quickly.

        • Re: Create sheet that contains all data behind an application?
          Mark Ritter

          I don't believe that there is a way to select all fields at one time and put them into a table so that you could then export the data.

           

          I would suggest that instead of exporting a large spreadsheet that you have a data sheet that show the most important data elements.  Then based on the selections made on other visualizations or filters the user will then see what they need as far as raw data to be able to determine why something looks the way it does on a chart.  Then if they desire to they can export that limited data to excel.

           

          I try to keep the user on the dashboard as much as possible to do their analysis. 

            • Re: Create sheet that contains all data behind an application?
              William Christensen

              Many of my visualizations have multiple set analysis conditions which are stored in variables. When I am validating the data, it is convenient to have a single sheet that shows my entire dataset so I can figure out if my set analysis logic is correct for my visualizations. To that end, I created a variable that returns the boolean result of the condition (True or False). I have lot of data fields and set analysis conditions so this "download page" creation is taking quite some time to build. I was just hoping there might be a fast way to build this out.... If not for this app, maybe for the future.

               

              As far as end users go, I agree with keeping them in the visualizations but the "download page' is handy when they apply a filter and see no results on a given visualization. The download page will show the potential records and then when all the T/F set analysis values show False it is easy to explain the seemingly incorrect blank chart as "working as designed".

            • Re: Create sheet that contains all data behind an application?
              William Christensen

              If I purchase NPrinting would that fix it? In SSRS, I can create a tablix report to download all fields from a view in no time. Is this truly something qlik sense can't easily accomplish?