Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Ad-hoc(Self service report) in Qlik Sense

Hi all,

Can anyone suggest me how to create ad-hoc kind of report (table) where, I will be having dimension and measure selection and whichever I select, only those dimensions and measures should get display in table.

Thanks!

2 Replies
Highlighted
Master
Master

I did something like this in an app.

I use an extension so that the user can pick the Dimension that they want.

I load an inline table that contains the choices from the filter along with the actual field value that I need to get the data.

  // Used to assign the correct field based on the selection made in filter on Patient Outcomes Sheet

Dimensions:

Load * Inline [

Display,Dim1

'By Facility','Facility'

'By District','District'

'By Region','Region'

'By MeasureDesc','MeasureDesc'

'By ReferralSource','ReferralSourceID'

'By PrimaryProgram','PrimaryProgramDesc'

'By SecondaryProgram','SecondaryProgramDesc'

'By DiagnosticGroup','DiagnosticGroupDesc'

'By MedicalDx','MedicalDxDesc'

'By FDScale','MeasureGroup_Scale'

'By EOC Destination','EOCDest'

];

In the table my dimension is defined as

$(='[' & only(Dim1) & ']')

The field in the filter extension is Display so that I can match it to the inline table.

Hope that helps as does what you want. 

Highlighted
Specialist
Specialist

Hey Thanks for reply!

can you share any demo app for the same and one more thing which extension you have used.