Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am working on a Qlik Sense map chart that includes two area layers and three point layers.
For one of the point layers, I need to disable selections for the column [Reporting Entity]. I am attempting to achieve this in the Size and Shape → Size by expression section.
I am using the following expression in the point layers:
sum(<[Reporting Entity]=>Sales)
However, it is not working as expected.
Could you please suggest an alternative approach or solution?
Your set expression is slightly off.
Use the set expression builder to help you create your set expressions.
1. Click on the chart you want to apply a set expression to
2. Select a dimensions ie: sportswear that you want to use in your set expression
3. Edit the sheet
4. find the measure in the chart
5. place your cursor and click in front of 'Sales' in this case ie sum(Sales)
6. Press on 'insert'
You can sse this technique to ensure your set analysis syntax is accurate.
Kind regards...
Hi,
As Frank_S is writing the expression is wrong. I would also like to add that you should use the set expression in all measures in the map layer. that would be the location and the size (and perhaps also in colour if you have an expressin there)
Location could be like: only({<[Reporting Entity]>} LocationField) where Location field should be the field you have your lat / long cordinates in.
And your size should be like this: Sum({<[Reporting Entity]>} Sales)
Best of luck 🙂
I tried but it wont work. PFA. Can you please disable filters for one of the fields in my test app.
Thanks
Hi,
Let's take an example for your dataset.
Create a point layer for each Province. Use Province Code for dimension and Province_LONG_LAT for location. The points will only show for your selections related provinces. But if you add a set expression to the measure (the location field) in the layer you can dissregard of the selections. then we need to also add a function, normally Only() in this case. So change the location to be only({1} Province_LONG_LAT) and all point will always show.
Problem now is that the color will only show for related selections. Solution is to add the {1} se extpression to you color formula, example sum({1} Sales). The same apply for the size of the point.
I hope this will help point you in the right direction.
Best Olof
I am still unable to understand this. Can you please make the required change in my attached qvf and share the example file with me.