iDiff_Values_2 automatic change to 195898285

[paulyeo11]

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

[sushil353]

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)

[paulyeo11]

Hi Sushil

why need the $ , can share with me ?

Paul

[sushil353]

hi paulyeo11

can u share the sample app.

sushil

[paulyeo11]

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.

[sushil353]

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

[paulyeo11]

Hi Sushi

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

Paul

[paulyeo11]

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

[paulyeo11]

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