Using set analysis with variables

[#1]

Hi,

I have a table Fact: Concept, Month, ValueEUR

And another table AuxTime: AuxMonth

I use the set analysis expression below:

Sum($<[Concept] = {'RESULTADO'} , [Month] = {'$(=MaxString([AuxMonth]))'}>ValueEUR)

If I use this expression directly in a Chart, the expression works right. However, if I create a variable and then I use the variable in the Chart, it doesn't work. The expression becomes

Sum($<[Concept] = {'RESULTADO'} , [Month] = {''}>ValueEUR)

What I do wrong?

[#2]

So, ignore all of my ramblings, although my solution worked for me before the answer above from NMiller is a MUCH better solution, I've just tried it and it works perfectly (and I'll now use that in my own apps).

Cheers all,

[#3]

I'm not sure that an intermediate variable will work. I tried it, but QlikView seemed to expand the variable and then expand the value of that variable and I ended up with the same blank spot in the formula.

To attach a document, click the Options tab at the top of the post page. Choose Add/Update Attachment and choose your file.

[#4]

Thanks all,

Till now, the best solution is the NMiller one's.