Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
QSense
Creator II
Creator II

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

3 Replies
QSense
Creator II
Creator II
Author

flight.png

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

shree909
Partner - Specialist II
Partner - Specialist II

Hi,

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

QSense
Creator II
Creator II
Author

Hi,

In flight check tab, The problem chart

After open document you will see