Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
sp2412red
New 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
Employee
Employee

Re: Finding Max in Expression in a chart.

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

Re: Finding Max in Expression in a chart.

  • Add Program As Dimension
  • Add MaxString(ProjectID) as expression
  • Add Man(Year) as expression
sp2412red
New Contributor III

Re: Finding Max in Expression in a chart.

Thanks it worked.