Two values on separate lines in one Qlik Sense pivot-table cell

[RushikeshYenpe]

Hello Qlik Community,

In a native Qlik Sense pivot table, I want the Actual measure cell to display the calculated result and Numerator/Denominator as two vertically stacked sections:

Actual

┌────────────────┐

│ 100.00% │

├────────────────┤

│ 98 / 98 │

└────────────────┘

Status

┌────────┐

│ ☀️ │

└────────┘

The required structure under each period should remain:

Actual | Status

I tried Chr(10) and Chr(13) & Chr(10), but the pivot table displays both values on the same line:

100.00% 98 / 98

Adding a separate Calculation measure works, but changes the structure to:

Actual | Calculation | Status

This also increases the overall table width.

Is it possible to display the calculated result and Numerator/Denominator as two vertically stacked sections within one Actual measure cell?

If this is not supported, is there a native solution using a calculated dimension, ValueList(), or another approach without third-party extensions?

Thank you.

[Anil_Babu_Samineni]

with native in Pivot not possible, either you have to go with Table or ValueList(). an example with second approach - check if that helps or share the expected result.

[RushikeshYenpe]

Thank you for the example. Our required orientation is slightly different because Period must remain horizontally across the top and Target Numbers must remain vertically as rows.

The expected layout is:

Target No. / Details April May

QK3

Actual Result 0.000 0.000

Numerator/Denominator 0 / 511 0 / 428

Status ☀️ ☀️

QP1

Actual Result 98 169

Status ☀️ ☀️

For calculated targets such as QK3, we need three child rows:

Actual Result

Numerator/Denominator

Status

For direct-count targets such as QP1, Numerator/Denominator is not applicable, so only these two child rows should appear:

Actual Result

Status

Is this layout possible in a native Qlik Sense pivot table using ValueList(), while keeping Period as the column dimension, Target No. as the main row dimension, and the ValueList() items as child rows?

Can the Numerator/Denominator child row be conditionally hidden for direct-count targets without leaving an empty row?

If this is not possible with ValueList(), is there another native approach within the Qlik Sense pivot table that can achieve this layout without using third-party extensions?

Thank you.

[Anil_Babu_Samineni]

do you mean like this?

[RushikeshYenpe]

Thank you for the example. The orientation is close, but our required layout is slightly different.

In the same native Qlik Sense pivot table, we want to keep only these two measure headers under each Period:

Actual | Status

Inside the Actual measure area, we want the Calculated Result on the first line and the Numerator/Denominator directly below it.

Expected layout:

Actual
100.00%
98 / 98

Status
☀️

We already tried adding a line break to the Actual measure using Chr(10) and Chr(13) & Chr(10).

However, the native pivot table removes the line break and displays both values on the same line:

100.00% 98 / 98

Adding Calculation as a separate measure works, but changes the layout to:

Actual | Calculation | Status

This increases the overall table width and does not match the required client layout.

Is it possible to use ValueList() or another native approach within the same Qlik Sense pivot table to display the Numerator/Denominator below the Calculated Result inside the Actual measure area, while keeping only Actual and Status as the visible measure headers?

For direct-count targets, only the Actual Result should appear because Numerator/Denominator is not applicable.

If this exact layout is not possible natively, could you please suggest the closest supported solution within the native Qlik Sense pivot table?

Thank you.

expected output as below  

Actual | Status

April

┌─────────────────────┬────────┐

│ Actual │ Status │

├─────────────────────┼────────┤

│ 100.00% │ ☀️ │

├─────────────────────┤ │

│ 98 / 98 │ │

└─────────────────────┴────────┘

[RushikeshYenpe]

Hello @Anil_Babu_Samineni 

Thank you for the example.

The attached image shows the exact output we want to achieve in the same native Qlik Sense pivot table.

We need to keep:

• QCDS, KGI/KPI, Target No., Target Item, and Official Target as row dimensions.
• Periods horizontally across the top.
• Only Actual and Status as the visible measure headers under each period.

[RushikeshYenpe]

Hello Team 

Thank you for the example.

The attached image shows the exact output we want to achieve in the same native Qlik Sense pivot table.

We need to keep:

• QCDS, KGI/KPI, Target No., Target Item, and Official Target as row dimensions.
• Periods horizontally across the top.
• Only Actual and Status as the visible measure headers under each period.
  
  kindly let us know is this possible or not