Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
mromrod22
Partner - Contributor III
Partner - Contributor III

Filters

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:

          Capture.PNG

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

Help me, please.

Very thanks.

8 Replies
sunny_talwar

May be MaxString([Selector Anual])

mromrod22
Partner - Contributor III
Partner - Contributor III
Author

Hi Sunny,

This point works perfectly. Only missing one.

Thanks.

sunny_talwar

Missing one?

mromrod22
Partner - Contributor III
Partner - Contributor III
Author

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

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

mromrod22
Partner - Contributor III
Partner - Contributor III
Author

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

sunny_talwar

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

Capture.PNG

mromrod22
Partner - Contributor III
Partner - Contributor III
Author

Month is other different field, Sunny.

Capture.PNG

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