topic Re: Filtered List Box in QlikView

Filtered List Box

Mon, 09 Feb 2015 10:34:28 GMT

Hi,

I have a requirement were I need to show the last 6 dates in a list box. I have tried to display the same using a formula as below the

The expression is as below:

but this does not appear to be producing the expected results. I am just getting an empty list box.

Please suggest.

Re: Filtered List Box

tresB — Mon, 09 Feb 2015 10:37:45 GMT

Try like:

If([Run Date]>$(=Max([Run Date],7)), [Run Date])

Re: Filtered List Box

Mon, 09 Feb 2015 10:51:31 GMT

Thanks Mate, but that doesn't seem to work and gave me the entire list of dates.

Re: Filtered List Box

Mon, 09 Feb 2015 10:59:07 GMT

Let me elaborate, what I am trying to do.

1. I have a Start and End Date list box that is shown on the dashboard

2. I am trying to add another list box that shows last 6 dates. This list box will serve as a guide to select the start and end dates. This should also not be filtered or affected by other fields hence its in a different 'state'.

Re: Filtered List Box

tresB — Mon, 09 Feb 2015 10:59:38 GMT

Perhaps your date field is not properly formatted(numeric at the backend). Try: =Max([Run Date]) in a text box. Do you get a number?

Re: Filtered List Box

Mon, 09 Feb 2015 11:00:16 GMT

Hi,

try with a variable

vDateMax:

=Date(Max(Fecha)-7)

And the follow expression:

=Date(IF(Fecha>=vDateMax,Fecha))

With this method you can change the number of days easy.

Re: Filtered List Box

krishna20 — Mon, 09 Feb 2015 11:03:07 GMT

Hi Try This

=aggr(only({<Run_Date={'>=$(=$(=vMaxRun_Date)-5)<=$(=vMaxRun_Date))'}>} Run_Date),Run_Date)

Variable->vMaxRun_Date =Max({1}Run_Date)

Regards

Krishna

Re: Filtered List Box

Mon, 09 Feb 2015 11:34:15 GMT

Thanks for the help but that didn't work either

Re: Filtered List Box

Mon, 09 Feb 2015 11:34:47 GMT

Tresesco, I am getting a date back

Re: Filtered List Box

Mon, 09 Feb 2015 12:53:08 GMT

Hi,

Try This

AGGR(if(Date>=$(=Max(Date)-7) and Date<= $(=Max(Date)),Date),Date)

=AGGR(ONLY({1<Date={'>=$(=Max({1}Date)-7)<= $(=Max({1}Date))'}>}Date),Date)

Regards

Nandkishor Pandirkar

Re: Filtered List Box

Mon, 09 Feb 2015 13:46:02 GMT

may be can you try like this

=If(Match([Run Date], $(=Max({1} [Run Date])), $(=Max({1} [Run Date]))-1,$(=Max({1} [Run Date]))-2),[Run Date])