3 Replies Latest reply: Feb 20, 2013 11:41 AM by ali ceyli

# Chart value not affected

Hi

I have an access db in that from one to thirty three columns

and they have "v","G""sI","NA" values in these columns

in script side ı wrote this statement

if(BIR='G',1,0) + if(IKI='G',1,0) + if(UC='G',1,0) + if(DORT='G',1,0) + if(BES='G',1,0)

+if(ALTI='G',1,0) + if(YEDI='G',1,0) + if(SEKIZ='G',1,0) + if(DOKUZ='G',1,0) + if(ON='G',1,0)

+if(ONBIR='G',1,0) + if(ONIKI='G',1,0) + if(ONUC='G',1,0) + if(ONDORT='G',1,0) + if(ONBES='G',1,0)

+if(ONALTI='G',1,0) + if(ONYEDI='G',1,0) + if(ONSEKIZ='G',1,0) + if(ONDOKUZ='G',1,0) + if(YIRMI='G',1,0)

+if(YIRMIBIR='G',1,0) + if(YIRMIIKI='G',1,0) + if(YIRMIUC='G',1,0) + if(YIRMIDORT='G',1,0) + if(YIRMIBES='G',1,0)

+if(YIRMIALTI='G',1,0) + if(YIRMIYEDI='G',1,0) + if(YIRMISEKIZ='G',1,0) + if(YIRMIDOKUZ='G',1,0) + if(OTUZ='G',1,0)

+if(OTUZBIR='G',1,0) + if(OTUZIKI='G',1,0) + if(OTUZUC='G',1,0)

as [G Sayısı]

This means from 1 to 33 if columns have G value in those column sum all of them

and [G Sayısı] is used in expression in chart

I wrote same statement in script side for each values (SI,G,NA,U..)

and chart I didnt put any dimension

But when ı select one of these values on chart they are not affected

if anyone wants I can attach QW files

• ###### Re: Chart value not affected

I want to add values (G,VG,SI,A,U) to dimension

• ###### Re: Chart value not affected

Hi,

if u attach a qvw file that will be good  to get an idea...

• ###### Re: Chart value not affected

Hi,

In flight check tab, The problem chart

After open document you will see