topic Re: iDiff_Values_2 automatic change to 195898285 in QlikView

iDiff_Values_2 automatic change to 195898285

paulyeo11 — Mon, 06 May 2013 05:43:00 GMT

Hi All

I make use of field name = iDiff_Values_2 for control number of var display on the chart. some how it work fine , but after reload , i notice that field = iDiff_Values_2 automatic change to 195898285

May i know how to prevent it from change to number ?

Paul

Re: iDiff_Values_2 automatic change to 195898285

sushil353 — Mon, 06 May 2013 06:17:09 GMT

hi,

is there any relation of 195898285 no in your database..?

while writing the variable name in the max show value.. use dollor sign expansion

$(iDiff_Values_2)

Re: iDiff_Values_2 automatic change to 195898285

paulyeo11 — Mon, 06 May 2013 06:39:31 GMT

Hi Sushil

why need the $ , can share with me ?

Paul

Re: iDiff_Values_2 automatic change to 195898285

sushil353 — Mon, 06 May 2013 06:40:31 GMT

hi paulyeo11

can u share the sample app.

sushil

Re: iDiff_Values_2 automatic change to 195898285

paulyeo11 — Mon, 06 May 2013 06:52:16 GMT

Hi Sir

The sample just a example only , it only can display 2 bar , which is not impt. key point is why the field name change to number.

Re: iDiff_Values_2 automatic change to 195898285

sushil353 — Mon, 06 May 2013 07:09:39 GMT

hi,

i could not figure out that why it is visible as no.. i am working on qlikview-11 which is not having same option as yours..

there is a suggession for your requirement is to have a variable instead of putting field name in Max visible number option.

create a variable say.. vbars=getfieldselections(iDiff_Values_2) and then use the varibale in Max visible number option as $(vbars).

Re: iDiff_Values_2 automatic change to 195898285

paulyeo11 — Mon, 06 May 2013 07:20:11 GMT

Hi Sushi

I try to create a var as per your mentioned. But it does not work.

Paul

Re: iDiff_Values_2 automatic change to 195898285

paulyeo11 — Mon, 06 May 2013 07:25:17 GMT

Hi Sushil

I just check it work fine now. I think now it is hard for QV to change variable name to number , because you create a interlock.

Thank you

Paul

Re: iDiff_Values_2 automatic change to 195898285

paulyeo11 — Wed, 12 Jun 2013 09:39:03 GMT

Hi All

I have follow Sushil advise , today i just notice that it auto reset to 195828.. , so i hope some one can advise me what is the work around to aviod this happen again.

Paul