topic Re: Help with Filters and Date in App Development

Help with Filters and Date

antoniodneto — Fri, 15 Mar 2019 15:14:10 GMT

Hi guys!

I have two problems.

The first one is: SHEET VS SAÍDA FINANÇAS

I created two list of filter using the script below.

Load * inline [

Dim

ESPECIAL

MASSIVO

SELECT

VAN_GOGH];

Load * inline [

Dim2

QTDE

RISCO

PDD

MBB];

It's ok when I use just one value in Dim, but when no one is select or when I select all, my tables didn't work, only if i choose one value.

How can I solve that?

The second is: (SHEET SAFRAS)

I have a pivot table with dates format in YYYYMM, I have dates since 2011 but I need to filter the max date and your last 25 months.

Follow my app attached.

Tks guys!!

jwjackso — Fri, 27 Apr 2018 20:32:01 GMT

On the first problem, try changing SEGMENTO_SIMULE={"$(=GetFieldSelections(Dim))"} to SEGMENTO_SIMULE=P(Dim).

antoniodneto — Mon, 30 Apr 2018 19:33:47 GMT

Hi Jerry!! The first problem was resolved... Tks a lot!!

And about the second? Can you help me?

Tks!!!