topic Re: Filters in QlikView

Filters

mromrod22 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I need apply filters in NPrinting, and read are same that in QlikView. But I don´t know how do the next filters:

All possible values of a month field (for example, I have data to June, the filter apply January to June).
Max value of the next field:

Need a expression that take a ultimate value of a ultimate year. In this case, need take "2016@Rev3"

Help me, please.

Very thanks.

sunny_talwar — Tue, 14 Mar 2017 10:50:19 GMT

May be MaxString([Selector Anual])

mromrod22 — Tue, 14 Mar 2017 11:06:11 GMT

Hi Sunny,

This point works perfectly. Only missing one.

Thanks.

sunny_talwar — Tue, 14 Mar 2017 11:10:19 GMT

Missing one?

mromrod22 — Tue, 14 Mar 2017 11:17:16 GMT

The first point. I exposed two filters:

All possible values of a month field (for example, I have data to June, the filter apply January to June)
ISSUE RESOLVED BY YOU

sunny_talwar — Tue, 14 Mar 2017 11:31:11 GMT

I am not sure I understand your first requirement... can you may be explain with an example?

mromrod22 — Tue, 14 Mar 2017 11:37:49 GMT

If I have data until August, I need filter since January to August. All values of field "month" when exist data.

sunny_talwar — Tue, 14 Mar 2017 11:46:40 GMT

What is August or July here? These seem like a different sort of YearMonth format?

mromrod22 — Tue, 14 Mar 2017 11:53:57 GMT

Month is other different field, Sunny.

I need with a filter all months that have data since "Ene".