Discussion board where members can get started with QlikView.
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:
So it has to work like this:
If no year is selected, the data shown would be:
If the year is filtered as 2007, the data should be shown as
So the Filter/ column to be added in the chart is Dynamic.
Can you please suggest how to accomplish this requirement.
View solution in original post
Thanks it worked.