Creating multiple Columns from SQL dbo data source - to replicate this report formatting in a Qlik sense app

christopher76 — Fri, 23 Sep 2022 10:13:36 GMT

I'm trying to figure out how to create a table with all required columns in qlik sense from a sql dbo.

This is what comes from the SQL report builder and pumped out:

The finance department want a 'like for like' App within Qlik Sense - as close to replicating the above format as posssible.

However, I'm relatively new to Qlik and just can't seem to make it happen.

The image below is a snapshot of what the App is looking like as I test dimensions and measures.:

But I just can't seem to achieve the right formatting to get 'Categories ' across the top.

I would be enormously grateful for any input and help.

Thank you

Chris

Re: Creating multiple Columns from SQL dbo data source - to replicate this report formatting in a Qlik sense app

Mark_Little — Mon, 03 Oct 2022 06:39:04 GMT

HI @christopher76

I think we would need to know a little more about the data model and the issue you are finding.

What have you tired?

It looks achievable, One thing i try to make clear when using Qlik is it analytical tool not a report designer, so for little thing you may lose you gain ten fold with the associative engine.

topic Creating multiple Columns from SQL dbo data source - to replicate this report formatting in a Qlik sense app in App Development

Creating multiple Columns from SQL dbo data source - to replicate this report formatting in a Qlik sense app

Re: Creating multiple Columns from SQL dbo data source - to replicate this report formatting in a Qlik sense app