topic Re: Show field after set-expression (no aggregation function) in QlikView

Show field after set-expression (no aggregation function)

jakobjensen — Thu, 27 Aug 2020 13:50:52 GMT

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?

Re: Show field after set-expression (no aggregation function)

tresB — Thu, 27 Aug 2020 14:11:47 GMT

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

Using if : If(year=2015, ID)

Re: Show field after set-expression (no aggregation function)

jakobjensen — Thu, 27 Aug 2020 15:11:59 GMT

Thanks!

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

Re: Show field after set-expression (no aggregation function)

Kushal_Chawda — Thu, 27 Aug 2020 15:36:55 GMT

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)