Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
That's the alternate state you have inherited your sheet from.
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?
See attached sample
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)
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).
But I would like to see for example Total Incurred
2015
2014
2013
Toat Paid
2015
2014
2013
and so on
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 |
I am not getting this, how did you get this? are u using expression Q1 NOt Working
Can you please attach ur qvw
Yes.
I am using QV 11.20 SR11 X64 right now.Which version are you using?