topic Re: ListBox Set Expression in QlikView

ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:01:28 GMT

I have a situation.

I have table like below. This is only sample. I have multiple entries.

Sector	Header
NAM
ASPAC	X
EMEA
LATAM	X
ASPAC
EMEA	X
NAM	X

I have a ListBox with expression : =If(Match(Sector,'ASPAC','EMEA','NAM','MEXICO-S','DIGITAL'),Sector & '--' & Header)

This results me something like below:

ASPAC--X

ASPAC--

EMEA--X

EMEA--

NAM--X

NAM--

MEXICO-S--X

DIGITAL--X

The Header field has X's and NULL's.

I want to display only Header with X's.

I have tried below expression, but could not achieve any.

=If(Match(Sector,'ASPAC','EMEA','NAM','MEXICO-S','DIGITAL'),Sector & '--' & FirstSorterValue(Header,-Ord(Header)))

=If(Match(Sector,'ASPAC','EMEA','NAM','MEXICO-S','DIGITAL'),Sector & '--' & MaxString({<Header={'X'}>}Header))

Any advise please..

Re: ListBox Set Expression

sunny_talwar — Mon, 11 Apr 2016 16:04:17 GMT

Try this:

=Aggr(Only({1<Header = {'X'}>} Sector & '--' & Header), Sector)

Re: ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:06:18 GMT

Amazing.. Sunny, The Rajini

Thank you so much.

It worked..

Re: ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:12:30 GMT

Hi Sunny,

I just changed a bit on this to list all the Values. It looks like, it returns only the Selected.

=Aggr(Only({1<Header = {'X'}>} Sector & '--' & Header), Sector)

Re: ListBox Set Expression

sunny_talwar — Mon, 11 Apr 2016 16:13:57 GMT

What did you change?

Re: ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:14:39 GMT

Hi Sunny,

Added 1 to the Expression instead of $.

Re: ListBox Set Expression

sunny_talwar — Mon, 11 Apr 2016 16:15:54 GMT

Hahahaha okay... I did update that in my response when I attached the sample

Re: ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:16:42 GMT

I'm sorry. It was there in your code. As I have typed it, I could have missed that one.

Sorry again... I over looked it..

Re: ListBox Set Expression

Saravanan_Desingh — Mon, 11 Apr 2016 16:17:17 GMT

Oh ok sure..

Re: ListBox Set Expression

sunny_talwar — Mon, 11 Apr 2016 16:17:29 GMT

No sorries my friend. I did add it at a later point. So totally not your mistake