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: 
Samrithi
Contributor III
Contributor III

Chart is getting selected when select other chart

Hi,

I have 2 bar charts one is created on direct dimensions and other is created on calculated dimensions.

when I select one bar on chart(Direct dimension) , other bar is getting changed and showing blank.

I know Qlik has associate in nature and associate on othe objects but I don't want change the other chart, so I used 

Identifier {1} in expression: count({1}Cashed).  

Dimension for the chart is:  ""Aggr( If ( last 3 yrs='Y' and last 2 yrs='N' , '3to2',

                                                       if( last 2 yrs='Y' and last 1yrs='N' , '2 to 1',

                                                         if( last 1 yrs='Y' and last 90days='N' , '3to2'))),cashed)"."

 

Appreciate the solution.

Thanks

                                                           

                                                        

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

if you the chart to be static 

add the {1} to your aggr argument 

Aggr({1} If ( last 3 yrs='Y' and last 2 yrs='N' , '3to2',

                                                       if( last 2 yrs='Y' and last 1yrs='N' , '2 to 1',

                                                         if( last 1 yrs='Y' and last 90days='N' , '3to2'))),cashed)

something like this should work , other wide the dimension in your aggr function is effected from your selections

Samrithi
Contributor III
Contributor III
Author

Hi, The replay I tried it already adding {1} after aggr but its not working.