topic Display Recent Month Red Programs in QlikView

Display Recent Month Red Programs

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

I'm currently using the following to display a count of recent month Red Programs:

=count(

[MonthYear2] = {'$(=max(MonthYear2))'}

(Red)

)

I want to display a list of the recent month Red Programs. What would the correct syntax be to display a list of the recent month Red Programs?

Re: Display Recent Month Red Programs

sunny_talwar — Thu, 06 Sep 2018 13:41:23 GMT

Display the list where? In a chart or list box object or somewhere else?

Re: Display Recent Month Red Programs

fanninam — Thu, 06 Sep 2018 13:56:18 GMT

Text Object would work. I'm just having a hard time with the syntax.

Re: Display Recent Month Red Programs

vishsaggi — Thu, 06 Sep 2018 14:11:29 GMT

You want count() or list of values to be displayed? And what is the format of your MonthYear2 field? It should have the same format in set analysis may be like below?:

=count({< [MonthYear2] = {"$(=Date(max(MonthYear2), 'MMMYYYY'))" } >} Red)

if you want to show the list of values in Red field for that max monthyear2 in text object may be use Concat() function.

= Concat({< [MonthYear2] = {"$(=Date(max(MonthYear2), 'MMMYYYY'))" } >} Red, Chr(13))