topic Value List Function Issue in Straight Table in QlikView

Value List Function Issue in Straight Table

Tue, 09 Feb 2016 16:29:38 GMT

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

Re: Value List Function Issue in Straight Table

swuehl — Tue, 09 Feb 2016 16:40:39 GMT

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?

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:06:33 GMT

See attached sample

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:07:47 GMT

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)

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 15:16:57 GMT

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).

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:23:49 GMT

But I would like to see for example Total Incurred

2015

2014

2013

Toat Paid

2015

2014

2013

and so on

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 15:28:45 GMT

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

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:40:39 GMT

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

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:42:13 GMT

Can you please attach ur qvw

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 15:43:18 GMT

Yes.

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

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 15:47:05 GMT

I am using SR12. Can you please attach your QVW, giving you this result

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 15:51:48 GMT

Attached.

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 16:06:03 GMT

The result you get if you dont do any selections in Year or month. As soon as you select a Year or MOnth, u loose the data.

Please check

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 16:47:51 GMT

There are some known issues with ValuesList and set expressions.

Maybe a solution could be achieved like in attached sample, reusing my approach from

About ValueList

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 16:55:42 GMT

What is MPL_Dol in the expression??

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 16:57:27 GMT

That's the alternate state you have inherited your sheet from.

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 19:08:26 GMT

Well when I implement the sample you sent me in my actual dashboard, it doesnt work again. I have defined the variable for year as you did and added the Alternate state. I actually copied the sheet object from your response and pasted in my dashboard

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 19:32:37 GMT

U have assigned a new state (AS) to the sheet object why is that? and what it is

Re: Value List Function Issue in Straight Table

swuehl — Wed, 10 Feb 2016 19:51:52 GMT

Have a look at the thread I referenced above.

I think this behaviour is a bug, and the only workaround I've found is setting the chart to a different state then the expressions.

In your QVW, there are a huge amount of alternate states already created. Not sure what they are made for, so I've just created on more, AS.

Re: Value List Function Issue in Straight Table

Wed, 10 Feb 2016 19:53:35 GMT

But why the sheet object is not inherited since we already assigned the alternate state at the sheet level