Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can you exclude items from listbox?

Hi All,

I have a field called [Reporting Date] where it has quarter dates. I want to create 2 listboxes for this [Reporting Date] field where i want to show in First Listbox and Second Listbox:

[Reporting Date]:

3/31/2015

1/31/2015

12/31/2014

9/30/2014

First Listbox: just want to show current or most current quarter. With the above quarter dates, it should only show "3/31/2015"

Second Listbox: It's the opposite to the first i want to show all quarters except "3/31/2015"

1/31/2015

12/31/2014

9/30/2014

I have tried "Only()" without any success. Any inputs will be greately apprecaited!

Frankie

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

Hello!

See attach. !

View solution in original post

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Use these expressions in the listboxes:

Aggr(If(InQuarter([Reporting Date], Today(), 0), [Reporting Date]), [Reporting Date])

Aggr(If(InQuarter([Reporting Date], Today(), 0), [Reporting Date]) = 0, [Reporting Date])

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

Hi Jonathan,

I tried both of your expressions in the listboxes but I couldnt get it right. can you see attached qvw to see if i missed anything? Thank You.

pokassov
Specialist
Specialist

Hello!

See attach. !

Anonymous
Not applicable
Author

Thank You!