not working as expected

[soniasweety]

Hi All,

i have two  charts and two listboxes     here the issue  with alternate state

dimension1 and dimension2 

chart1 and chart2

so am using   state1 for  dimenson 1 and chart1

state2 for diemsion2 and chart2

issue:   when i select in chart2  chart 1 also   reflecting 

what might be the issue?

used xpression  for chart1: =sum({<[Type]= ,Dimension2= ,Measure2= >}[Amount])/$(vFormat)

used xpression  for chart2: =sum({<[Type]= ,Dimension1= ,Measure1= >}[Amount])/$(vFormat)

variable:  vFormat=FormatId

format id is field  and having values  1000,10000

thanks

Sony

[dx_anupam]

Hi Sony,

Along with the charts you have to specify respective alternate state to list box as well.

Regards,

Anupam

[gavinigovind452]

can you share QVW

[soniasweety]

   any inputs Sunny Talwar

[tresesco]

Could you share a sample app showing the issue?

[manoj217]

=sum({state1<[Type]= ,Dimension1= ,Measure1= >}[Amount])/$(vFormat)

=sum({<state2[Type]= ,Dimension2= ,Measure2= >}[Amount])/$(vFormat)

[soniasweety]

already tried . but still not working

[soniasweety]

sample its working  .. main app in server i cant take it out

[manoj217]

check if any states have created in before in the same name

[soniasweety]

in dimension used below expression

if(SubStringCount(vDimensions,'Type'),1,0)    conditional dimenison [bcz its adhoc report]

anything wrong here?

[manoj217]

Please go through this https://www.analyticsvidhya.com/blog/2014/01/customize-reporting-qlikview/