topic Re: Multiple selection not working as expected in QlikView

Multiple selection not working as expected

soha1902 — Thu, 21 May 2015 05:47:40 GMT

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.

Thu, 21 May 2015 06:57:44 GMT

Can you post the qvd?

avinashelite — Thu, 21 May 2015 07:54:19 GMT

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 — Thu, 21 May 2015 08:15:35 GMT

Any Suggestions please

qlikviewwizard — Thu, 21 May 2015 08:17:23 GMT

Can you share sample file?

antoniotiman — Thu, 21 May 2015 08:29:27 GMT

Hi,

try to add Concat() in Your expression like

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

Regards,

Antonio

Anonymous — Thu, 21 May 2015 09:16:07 GMT

Hi Soha,

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

Thanks

BKC