Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jakobjensen
Contributor II
Contributor II

Show field after set-expression (no aggregation function)

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?

 

2 Solutions

Accepted Solutions
tresesco
MVP
MVP

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

Using if : If(year=2015, ID)

 

View solution in original post

Kushal_Chawda

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)

View solution in original post

3 Replies
tresesco
MVP
MVP

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

Using if : If(year=2015, ID)

 

View solution in original post

jakobjensen
Contributor II
Contributor II
Author

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

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)

View solution in original post