topic Listbox in QlikView

Listbox

Tue, 14 Jan 2014 09:42:48 GMT

Hello everyone,

Little yet annoying problem, I have a listbox with a set of dates, however, I want it to show dates for only the period from 04/11/2013 till 27/11/2013. I tried putting it into sort by expression, but it still returns dates for December too.

Thank you!

Anna

Re: Listbox

datanibbler — Tue, 14 Jan 2014 09:47:08 GMT

Hi Anna,

if you right-click your listbox, in the context-menu you have a subpoint "Advanced search" where you can enter complex search_expressions including IF constructs.

Try entering something along the lines of this:

>>> = [date] >= '04/11/2013' AND [date] <= '27/11/2013' <<<

HTH

Best regards,

DataNibbler

Re: Listbox

Tue, 14 Jan 2014 09:52:42 GMT

Thank you, but this only provides the search, whereas I'm looking at the listbox displaying only those dates. With expression you have supplied, it searches for the required dates, however, irrelevant dates are still displayed.

Anna

Re: Listbox

bruno_m_santos — Tue, 14 Jan 2014 10:02:46 GMT

In List Box, try buil an expression,

if ( [date] >= '04/11/2013' AND [date] <= '27/11/2013' , [date], null())

Bruno

Re: Listbox

sujeetsingh — Tue, 14 Jan 2014 10:08:50 GMT

See the sample

In the sample i have just used ad ID in List box but you can see the logic of filltering the value.