topic Re: need qv example on valuelist() in QlikView

need qv example on valuelist()

paulyeo11 — Sun, 07 Jul 2013 11:55:08 GMT

Hi All

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/01/valuelist-for-those-tricky-situations

after reading above blog post , i still not understand , hope some one can give me example on qv doc.

paul

Re: need qv example on valuelist()

swuehl — Sun, 07 Jul 2013 11:57:30 GMT

Just follow today's discussions.

Re: need qv example on valuelist()

paulyeo11 — Sun, 07 Jul 2013 12:18:11 GMT

Hi Sir

yes this is what i want to know. many thank.

i notice by using valuelist () , i don't need to write extra script at load script.

i notice that after you hide the cal 2 on budget , the cal 2 actual value change . see the enclosed qv doc. may i know why the value change it is normal ?

Re: need qv example on valuelist()

paulyeo11 — Sun, 07 Jul 2013 12:23:14 GMT

i think iknow the reasons , because the field = rand. but i not sure what is rand , it is some thing like QV command ?

Re: need qv example on valuelist()

swuehl — Sun, 07 Jul 2013 13:38:50 GMT

Just check the Help file:

rand( )

Returns a random number between 0 and 1.

Re: need qv example on valuelist()

paulyeo11 — Mon, 08 Jul 2013 00:36:22 GMT

Thank you sir