Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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".