topic Re: Select values from dimension with a variable in QlikView

Select values from dimension with a variable

Thu, 13 Jun 2013 14:45:21 GMT

Gretting, I have a little problem.

I have the dimension year and month. The years are 2009 to 2013, the month are complete. In the relation Year-Month, for the case of 2013, its last month is June (6).

So, I need select the max month for every year when I select the year. In other word, when I select 2009 or 2012, the max month should be 12, and when I select 2013 the max month should be 6.

I create a variable just like that: =If( Year = Max(Year), Max(Month) )

It works, the default value of the archive is the max year, 2013, and select June (6) , but when I select other year, the month not change to 12. If I erase all the filters, and I select 2012 to 2009, the max month is 12, and when I switch to 2013, the max month changs to 6.

The problem is that, for default the year is 2013, and select its max month, but if the first thing that I made is select other year, the max month for 2013, June (6), remain selected, and I need the month change every time that I select a year.

I put a trigger in the dimension 'Year', that take the value for the variable, that's the way that I made.

Any suggestion?, I hope to find a solution.

Thanks.

Re: Select values from dimension with a variable

Thu, 13 Jun 2013 16:35:59 GMT

No one can help me?, or Didn't I explain it correctly? 😕

Re: Select values from dimension with a variable

Anonymous — Fri, 14 Jun 2013 06:24:42 GMT

Can you post a sample application ? It is hard to understand what you mean.

Jonathan

Re: Select values from dimension with a variable

Fri, 14 Jun 2013 13:21:52 GMT

I want to see this:

I select one year, and immediately the report select the last month of that year.

On the case of this year, it's June. A sequence of that I want:

Select 2013 ----------------> Report select June

Select 2011 ----------------> Report select Decembrer

Select 2009 ----------------> Report select Decembrer

Select 2013 again -------> Report select June

Select 2009 again -------> Report select December

Select 2013 again -------> Report select June

Thanks.

Re: Select values from dimension with a variable

Anonymous — Fri, 14 Jun 2013 14:23:11 GMT

creat a variable and use it as a trigger vmax = max(year)

And create a variable just like that: =If( Year = ' $(vmax) ', Max(Month) )

hope it helps

Thanks

Re: Select values from dimension with a variable

jonathandienst — Fri, 14 Jun 2013 14:47:08 GMT

I think you need something like this:

=Max({<Year = {"$(=Max(Year))"}, Month = >} Month)

Hope that helps

Jonathan

Re: Select values from dimension with a variable

Fri, 14 Jun 2013 14:55:26 GMT

It's work perfectly, thanks.

Do you can me explain why use vmax with the sign '$' and the single quotes?.

Thanks you, regards.

Re: Select values from dimension with a variable

Fri, 14 Jun 2013 15:17:03 GMT

Works, but when I use like a trigger on the dimension Year, don't work again. Still remain "June" perhaps I change the year 😕