Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
julian_rodriguez
Partner - Specialist
Partner - Specialist

Expressions with Set Analysis

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

1 Solution

Accepted Solutions
Patric_Nordstrom
Employee
Employee

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

View solution in original post

5 Replies
Patric_Nordstrom
Employee
Employee

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

julian_rodriguez
Partner - Specialist
Partner - Specialist
Author

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

julian_rodriguez
Partner - Specialist
Partner - Specialist
Author

Any suggestion, Patric?

Thanks in advance   

Julian

Patric_Nordstrom
Employee
Employee

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

julian_rodriguez
Partner - Specialist
Partner - Specialist
Author

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