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
Contributor III
Contributor III

Finding Max in Expression in a chart.

Hi,

I have a requirement to identify the max of the ProjectID  along with the Dimension selected. There are many dimensions (Year, Region, etc).

This is the sample data:

   

Program ProjectIDYear
AA.12007
AA.22008
AA.32009
AA.42010
AA.52007
AA.62008
AA.72009
AA.82010
BB.12007
BB.22008
BB.32009
BB.42010
BB.52007
BB.62008
BB.72009
BB.82010
BB.92007
BB.102008
BB.112009

So it has to work like this:

If no year is selected, the data shown would be:

   

Program ProjectIDYear
AA.82010
BB.112009

   

If the year is filtered as 2007, the data should be shown as

   

Program ProjectIDYear
AA.52007
BB.92007

So the Filter/ column to be added in the chart is Dynamic.

Can you please suggest how to accomplish this requirement.

Thanks,

SP

1 Solution

Accepted Solutions
Highlighted
Employee
Employee

  • Add Program As Dimension
  • Add MaxString(ProjectID) as expression
  • Add Man(Year) as expression

View solution in original post

2 Replies
Highlighted
Employee
Employee

  • Add Program As Dimension
  • Add MaxString(ProjectID) as expression
  • Add Man(Year) as expression

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks it worked.