topic Re: Advanced Label to match expression in QlikView

Advanced Label to match expression

Mon, 02 Mar 2015 11:28:32 GMT

Hi all, I'm try to get a correct label together to tell the use exactly what the set analysis is currently doing.

So for the label I currently have:

='Sales ' & Max(Year)

& chr(10) & MinString(Month) & '-' & MaxString(Month)

So without ANY (on year or month) selections it shows Sales 2015 Jan-Dec. Now we all know that currently there are no more than 3 months in 2015 so far. So I would like it to show Sales 2015 Jan-Mar instead! The expression is already doing exactly that, but if the user has no selections the label shows something incorrect with respect to the expression.

Can somebody help me out on this?

Thanks,

Coen

Re: Advanced Label to match expression

Mon, 02 Mar 2015 11:35:35 GMT

Drop in a monthend(Today()) or similar for the Max value..

Re: Advanced Label to match expression

sunny_talwar — Mon, 02 Mar 2015 11:42:56 GMT

Maybe this

='Sales ' & Max(Year)

& chr(10) & MinString(Month) & '-' & MaxString({<Year = {'$(=Max(Year))'}>}Month)

The set analysis within the last MaxString will only show the max month for the maximum year which would be 2015 in your case.

HTH

Best,

Re: Advanced Label to match expression

Mon, 02 Mar 2015 11:48:07 GMT

Thanks! Works exactly as required.

Re: Advanced Label to match expression

sunny_talwar — Mon, 02 Mar 2015 11:50:50 GMT

Awesome. I am glad I was able to help.

Have a good one.

Best,