Repeating Dimension Values

[FrankC]

Hello

I would like to suppress a dimension value if the value above is the same value.  I want to do this in a straight table.

Thanks

Frank

[Benoit_C · Accepted solution]

Hello,

With Qlik Sense you might be able to do it by using set analysis.

You could try the below:

1. Create a new calculated field that checks if the current dimension value is the same as the previous dimension value:

if(Peek(FieldName) = FieldName, 0, 1) as Display

2. Use this calculated field as a dimension in your straight table:

Dimension: Display

3. In the expression for the column in your straight table, use set analysis to only display values where Display is 1:

Sum({<Display = {1}>} [Measure Field])

This should suppress repeating dimension values in your straight table, only displaying unique values. You can adjust the logic in the calculated field as needed based on your data and requirements.