Reproducing multilayer distribution chart from R to QlikSense. Filtering for highliting choice not for reducing data

[dangeneire]

Good morning,

For the project  Consumer  Condition survey I have to reproduce  the following  R Dashboard in QlikSense:

As you can see here the selection of the countries in the filter indicator, does not provoke a filtered  data but an red dot point (that is first plan respect the gray dot that correspond to no selected countries. Same thing for the blue dot corresponding to EU 27) in the chart and a red row in the corresponding table and the rest of data remains unchanged in gray.

Have you some idea how we could reproduce this on QlikSense?

I tried using the alternate state and it appears to work for the EU27 in blue, but for the chart I do not have the blue dot in first plan. For the selected country from filter pane the same thing does not work.

Here an overview of my tests

I had thought to simulate 3 layers with 3 chart superposed with different transparencies, but this does not appear possible now in #QlikSense. I thought also to use the alternate dimension but it does not appear functional because the 3 situations  (blue for EU27, red for selected country, gray for the countries not selected.) could be visible  at same time as in the R dashboard

Do you have any suggestion? Does it exist a better version of the distribution chart extension certified that we could use on “our” QlikSense Server in the European Commission? I am available for some interactive meeting for founding a solution if possible.

Daniele Gentile

[Clement15]

Hello,

Please include {<Country=>} in your measure, then experiment with the following formula in a color expression:

{1}if( Country=GetFieldSelections(Country),red(),if(Country='EU27',blue() ))

I hope this will meet your expectations.

[dangeneire · Accepted solution]

Good Afternoon,

I found a solution, I left the Filter Pane of the country as that, and I applied an Alternate State AS_Country_Chosen to the other Filter Pane Indicator and to the Distribution Chart. I created a Global variable v_single_MS = GetFieldSelections([country]) associated to the same Alternate State. In this manner I have any data reduction as expected and I could use the Fiilter Pane of the Country for Highlighting with this formula =if(country='EU27',ARGB(255,0,0,255),if(country=v_single_chart,ARGB(200,255,0,0),ARGB(25, 192, 192, 192))) . In this last formula I should manage also the transparency for highlighting red and blue dot comparing to grey dots. Here the results:

Kind Regards

Daniele Gentile.

[dangeneire]

Now I have a little other problem:  for some Filter Pane, as Country here in the previous screenshot I need to impose a single selection (i.e. from the filter pane I have to chose only one country per times). I imposed,  for the field country, this single selection via the activation on the field/dimension "country"  of the option  Always one selected value, but after  the Alternative State  "AS_Country_Chosen" applied on the chart and to Filter Pane indicator appear disabled, and all the Highliting on the table and on the chart appear lost. Do you know some alternative  for imposing this single selection without having unpleasant waferboard effect?

[Clement15 · Accepted solution]

I don't think there is a native solution to work around this issue. You can try to address it by setting a display condition in the chart. This doesn't actually solve the problem but prevents the user from using the chart with multiple selections.

if(GetSelectedCount(Country)>1,0,1)

[dangeneire]

Hi, thanks Clement15,

I created a global variable where I use the formula suggested by you and I could use that for "graying" (disabling) the chart too as you can see on this screenshot:

Another stuff if possible: in QlikView was possible to allow the word wrap on the value of a dimension (in this chart the label are downstairs). Does it possible in QlikSense, in some part to manage that in the chart? I tried to decrease the dimension of character, but  was not sufficient.