topic Re: ListBox in QlikView

ListBox

vanderson009 — Fri, 11 Jul 2014 04:50:55 GMT

Hi guys,

I have 12 Month of Data, I have list box which shows 12 Month.

but i want only show lates 6 month, for that what expression should i use.

- Thanks in advance,

Villyee

its_anandrjs — Fri, 11 Jul 2014 04:57:48 GMT

The last 6 months expressions is

In load script

Ex:-

Load

tempdate,

IF(YourDateField> AddMonths(MonthStart(Today()),-5), Month) as Last6Months

From Location;

Or in front end write in any list box

IF(YourDateField > AddMonths(MonthStart(Today()),-5), Month)

VishalWaghole — Fri, 11 Jul 2014 05:17:31 GMT

Try this,

=IF(Date > AddMonths(MonthStart(Today()),-6), Month)