I want to display the fields and the respective values in the text box or as title .

[Qlikuser09]

= Aggr( If( Match([Status], 'No ', 'Yes', 'In Work'), [VIP Rsp Status] & ': ' & Count({<[VIP Rsp Status]={'No ', 'Yes', 'In Work

'}>}[Status])

    ),

    [Status]

)

Expected Result

No : 2

Yes : 3

In progress :4

The above code works only hen the field is selected , but i need the values to be displayed irrespective of the selections made

[BrunPierre]

Perhaps?

Concat(Aggr( If( Match([Status], 'No ', 'Yes', 'In Work'), [VIP Rsp Status] & ': ' & Count({<[VIP Rsp Status]={'No ', 'Yes', 'In Work'}>}[Status])),[Status]),', ')

[vinieme12]

As below

concat({<Status={'Yes','No'}>} Distinct aggr([VIP Rsp Status] &':'&count(Status),Status), chr(10))