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

[christopher76]

Hi 

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

[Mark_Little]

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.