Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Display Recent Month Red Programs

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?

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

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))

View solution in original post

3 Replies
Highlighted

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

Highlighted
Creator
Creator

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

Highlighted
Champion III
Champion III

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))

View solution in original post