topic Re: List Box in QlikView

List Box

upaliwije — Fri, 28 Jun 2019 09:18:04 GMT

Hi Friends

I have a list box in my Q doc as shown below. This list box show all the date of the periods. I want to show only Month end Date of month. Pls hlep me

Re: List Box

jonathandienst — Fri, 28 Jun 2019 09:31:05 GMT

You could create a calculated dimension:

=Aggr(If(Current = Floor(MonthEnd(Current)), Current), Current)

But a better solutions to create the month end as a different field in the load script, or set a flag value for the month ends:

LOAD ... Current, Date(Floor(MonthEnd(Current)) as CurrentME, ...

Re: List Box

Brett_Bleess — Tue, 06 Aug 2019 15:18:23 GMT

Did the poster's response get you what you needed? If so, please be sure to click the Accept as Solution button to give them credit. If you still need further help, please update with a new post.

Regards,
Brett