Value List Function Issue in Straight Table

[#1]

I am using value list function  as a dimension along with year as a second dimension.  BUt I get $0 and , its giving me current year also, even though my expression does not include max year.

If I remove the Year dimension the chart works.

Can you please help with this

[swuehl]

Not easy to answer with the information provided. Could you upload a small sample QVW that demonstrates your issue?

In Output.png, there is an error indicated in your calculated dimension, could you detail this error message?

Also, what is the exact definition of your variable you used in the dimension?

[#3]

See attached sample

[#4]

Attached a sample qvw.  I have 2 Expressions in there.

Q1 not working  ( thats the one I want to work using ValueList)

Q2 working  ( just example not using the Valuelist)

[swuehl]

Sorry, what is the issue you are seeing?

Your expressions are using set analysis to override selection in year:

Sum({<Year={$(=Max(Year)-1),$(=Max(Year)-2),$(=Max(Year)-3)},MPL_Flag={'1'}>} Total_Incurred)/3)

That's why you don't see values for the max possible or selected year (like 2016).

[#6]

But I would like to see for example Total Incurred

2015

2014

2013

Toat Paid

2015

2014

2013

and so on

[swuehl]

I do see something like this using your Q1 expression:

	Year	Q1 NOt working
Total Incurred	2015	$-8073620516
	2014	$-7665313034
	Total	$-15738933550
Indemnity Incurred	2015	$-19884710520
	2014	$-18880138485
	Total	$-38764849003
DCC Incurred	2015	$5025654657
	2014	$4771799173
	Total	$9797453830
Paid Total	2015	$7072676259
	2014	$6715212463
	Total	$13787888721
Paid Indemnity	2015	$-5308042057
	2014	$-5039906944
	Total	$-10347949002
Paid DCC	2015	$2439038839
	2014	$2315740423
	Total	$4754779261
Total Case Reserves	2015	$-11990052643
	2014	$-11384172790
	Total	$-23374225435

[#8]

I am not getting this, how did you get this?  are u using expression Q1 NOt Working

[#9]

Can you please attach ur qvw

[swuehl]

Yes.

I am using QV 11.20 SR11 X64 right now.Which version are you using?