Raw Data Extraction

[Silviya_Angelova]

Hello everyone!

I have been using Qlik Sense for like 6 months and now I need to implement a solution that I once managed to develop in SSRS. After preparing all app charts with business needed content, the end user wants to slice some data from the raw extraction (no aggregations applied). I thought that creating a simple table and drag-and-drop of source columns would do the trick but it turns out that this is not how we do it here.

Data is coming from SQL Server view, so imagine that you execute it in SSMS(its own IDE) and as a result you have a table. I need to be able to give the end user the option to exact this exact table somehow. Do you know if this is possible or if there is some extension solution to do this? I found this: https://github.com/stefanwalther/sense-export#why which seems nice, but again it does the same thing that I already tried. Maybe I need something similar but leading to Export action directly from the In-Memory data(before participating in the main app).

Thank you in advance!

[lironbaram]

hi 

does the raw data is in the qlik sense app 

if so just build a table with the raw data fields , and than the user can extract the data 

or if the raw data is not part of your qlik sense app

you can look into ODAG 

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/DataSource/Manage-big-da...

https://community.qlik.com/t5/Qlik-Sense-Enterprise-Documents/On-demand-App-Generation-ODAG-in-QlikS...

[Silviya_Angelova · Accepted solution]

@lironbaram, thank you for the suggestions. They were helpful.

Anyway, I finally came up with a different solution (an easy one) - it is an extension called QlikTableViewer by Christof Schwarz & Ralf Becher.  What is important to point here is that in order to get the raw data sum to fit the sum of the aggregated values you need some GUID (if there are duplicates in your data). Without GUID the extension removes the duplicates and the results will never be the same.