topic Re: Formatting Data in Tables / Pivot Tables in App Development

Formatting Data in Tables / Pivot Tables

Markbhai — Wed, 01 May 2024 08:05:45 GMT

Hi All.

Having done some research I suspect I cannot get to what I want to achieve here, but this community has been great at helping so here goes.

I want to produce a table which is formatted in a more grouped manner (similar to a Pivot Table maybe), but rather than showing measures in the columns I need to show Dimensions - see example:

Category & Control	In Scope	Implemented	Evidenced	Evidence Description
Asset Management
- Asset Ownership	Y	Y	Y	Policy Document
- Return of Assets	Y	N
- Inventory of Assets	N
People Controls
- Employee Screening	Y	Y	Y	HR File Records

In my ideal output rows would be grouped by the Category with the 'Controls' grouped by category (e.g. - Asset Ownership).

Is there functionality in Qlik to do this, or if not are you aware of a extention which might help?

Thanks once again.

Mark.

Re: Formatting Data in Tables / Pivot Tables

Or — Wed, 01 May 2024 09:30:11 GMT

I don't quite follow the requirement. If the top row is dimensions, what's the left row? If it's measures, this is doable with a regular pivot - simply drag the dimensions to the Column section and the Values into the Row section:

Re: Formatting Data in Tables / Pivot Tables

Markbhai — Wed, 01 May 2024 11:33:15 GMT

Thanks Or,

The requirement is to display data in a table form where text is shown in the column fields, as in the example shown above and also have the left hand column grouped by Category and Control.

A pivot table allows me to do the grouping, but the display of the remaining colums is numbers only (not text),

I am not sure that presenting tables as text is the purpose of the Pivot, which is much more aligned to analysis of numbers.

Thanks

Mark.

Re: Formatting Data in Tables / Pivot Tables

Or — Wed, 01 May 2024 12:02:48 GMT

Assuming you have a singular text value, you can display it using Only().

There's a handful of aggregations functions that will take text - you can find them here: https://help.qlik.com/en-US/sense/February2024/Subsystems/Hub/Content/Sense_Hub/Scripting/StringAggregationFunctions/string-aggregation-functions.htm