topic Re: Variable doesn't return values unless the input object is open in QlikView

Variable doesn't return values unless the input object is open

Anonymous — Fri, 14 Feb 2014 19:17:05 GMT

A little background:

I'm trying to create a function that basically allows me to switch a report between a $ view (PMPM) and a % view (Admin Rate). These two views require different denominators, which can be indexed as 1 or 2. What I want to do is to select between PMPM and Admin Rate, and have a variable that returns 1 or 2, so that I can use the variable as the denominator in my set analysis formula.

Grp4Options	Grp4OptionDescrip
1	PMPM
2	Admin Rate

I set up a variable as below, which works sometimes, but....

vOptionGrp4=FieldValue('Grp4Options',FieldIndex('Grp4OptionDescrip',Grp4OptionDescrip))

It seems to me a random event that sometimes the variable won't return any value, then I find out that if, on the same sheet, I have a input object open that shows the variable and it's value, it works perfectly (at least so far....). But as long as I delete or even just minimize that object, the variable stops working again. I have another input object on another sheet that shows this variable as well, but it doesn't help.

Has anyone happen seen the same issue before? Any thoughts what could be the issue?

Thanks for your help!

Re: Variable doesn't return values unless the input object is open

Fri, 14 Feb 2014 19:26:16 GMT

Hey Yuehan,

Possible to attach a sample file.

Thanks

Re: Variable doesn't return values unless the input object is open

Anonymous — Fri, 14 Feb 2014 19:51:39 GMT

Hard to tell without the QVW file.

CB.

Re: Variable doesn't return values unless the input object is open

Anonymous — Fri, 14 Feb 2014 20:09:26 GMT

Sorry my file is too complicated to share. I think it might have something to do with the alternate states I'm using. Is there a way to specify this variable in one state? Something like we can put {[Group1]} in a set analysis.

Thanks!