Show field after set-expression (no aggregation function)

[jakobjensen]

I want a list of a field "ID" based on a set-expression e.g "year={2015}". I know I can do sum, count etc. but can't I just simply show the fields with no aggregation?

[tresesco · Accepted solution]

Using set analysis: Aggr(Only({<year={2015}>}ID), ID)

Using if : If(year=2015, ID)

[jakobjensen]

Thanks!

My question was moer, how do you visualize it? Do you use a table chart, and use it as a measure or...?

[Kushal_Chawda · Accepted solution]

You can  display ID in Listbox without using aggregation functions. You can use below in listbox expression(listbox->dropdown->end of the list click expression). You can also use this expression in any chart as calculated dimension

Aggr(Only({<year={2015}>}ID), ID)