5 Replies Latest reply: Nov 10, 2017 9:40 AM by Julian Rodríguez RSS

    Expressions with Set Analysis

    Julian Rodríguez

      Hello Experts,

       

      I have used Qlik Geoanalytics to visualize some facts.

       

      I have an YTD expression on a pivot table, the user selects a Month (for example June) and the expression calculates the facts from January 01 until the max date (June 30th)

       

      But, if I use this expression on the Bubble layer, the user must select all the months to get this. If only selects June, the data will be from June 01 until June 30.

       

      Please find a QVF with the data and expressions, really is frustating to see that the bubble layer doesn't suppor set analysis.

       

      Thanks for your help

       

      Julian

        • Re: Expressions with Set Analysis
          Patric Nordström

          Hi Julian,

          About set analysis, that will work in the layers of Qlik GeoAnalytics, just like with other extensions.

          The bubble layer is like a table with one dimension and expressions, it's often practical to make a table with a the same configuration to check that the expressions evaluates as planned.

           

          Thanks,

          Patric Nordström

          Qlik

            • Re: Expressions with Set Analysis
              Julian Rodríguez

              Hello Patric

               

              Thanks for your answer,

               

              If this is the expected behavior, then I thing that I'm doing something wrong.

               

              I'm using the expression on the "Bubble Size" option, is that right?

               

              I'll try to explain the requirement, so may be you can help me to find out the problem;

               

              I'm attachin 3 screenshots with a qlikview application, using just bubble layer and a base map on it.

               

              The expression on the table is the same than the expression on the "bubble size" option of the bubble layer.

               

              This is the expression, YTD for the year 2015, until september (septiembre, in spanish)

               

              Sum({$<FECHA_HECHO = {">=01/01/2015<=30/09/2015"}, AÑO=,SEMESTRE=,TRIMESTRE=,MES=,MES_LARGO=,NoSEMANA=,CONSECUTIVO_SEMANA=,SEMANA_HECHO=,SEMANA_LARGA=,DIA=,DIA_SEMANA=>}CuentaHechoHomicidiosComunes)

               

              It's just aggregating the field CuentaHechoHomicidiosComunes, starting from January the 1st until September 30th from 2015, and ignoring the selections on the others fields from the calendar table.

               

              If I want to see the 4 points found on this period on the map, I must select all the months from Jan to Sep, but if you can see, on the straight table, there is not need to do this (as I expected with the map)

               

              So, that's my doubt about the behavior of Geoanalytics with Set Analysis. It's not the same behavior map vs. straight table, as you said before.

               

              I will appreciate your opinions or advices

               

              PD: Please note that the map is getting "Error adding feature (4) when I select only 2015 september, on the data. What is that?

               

              Thanks

               

              Julian

              • Re: Expressions with Set Analysis
                Julian Rodríguez

                Any suggestion, Patric?

                 

                Thanks in advance   

                 

                Julian

                  • Re: Expressions with Set Analysis
                    Patric Nordström

                    Hi Julian,

                    To your test table, add the expression for long lat, make sure that they evaluate.

                     

                    Map window properties - Appearance -> Interaction and Control -> Log level

                    Set to debug to get more info.

                     

                    Thanks,

                    Patric Nordström

                    Qlik

                      • Re: Expressions with Set Analysis
                        Julian Rodríguez

                        Hello Patric

                         

                        Your suggestion helped me to find the light on the end of tunnel haha...

                         

                        I didn't applied the set analysis on the LAT and LONG expressions, and it seems that is the reason why the data visualization was wrong.

                         

                        I have aggregated the LAT and LONG values, using the AVG function, and then applying the set analysis, and it seems to be worked.

                         

                        My mistake, Geoanalytics do supports set analyisis, as you said,

                         

                        Thanks

                         

                        Julian