Multiple selection not working as expected

[soha1902]

Hi All,

I have 2 stacked bar chart in my dashboard(Chart A and Chart B). In both the charts, I am using 2 cyclic group as Dimension and 1 expresssion.

Chart A showing the main field in X-Axis as per selection through cyclic group and chart B showing sub fields for the main fields.

If I select only one field from chart A then corresponding sub fields in chart B showing correct total

but when I make multiple selection in chart A then values are not matching in chart B. Please see below image:

Thanks.

[#2]

Can you post the qvd?

[avinashelite]

I think while comparing more than one field its failing....check the format in this code

$(=GetCurrentField(X1.Axis))......when you have multiple selection it will be sepaerated by , and  space.....so might be failing in this point

[soha1902]

Any Suggestions please

[qlikviewwizard]

Hi soha1902,

Can you share sample file?

[antoniotiman]

Hi,

try to add Concat() in Your expression like

=Concat(DISTINCT $(=GetCurrentField(X1.Axis)),',')

Regards,

Antonio

[Anonymous]

Hi Soha,

If you can share the sample qvw file of your problem . that would be helpful for others to help you .

Thanks

BKC