How filter a sum of the values ​​of a list

[#1]

How filter a sum of the values ​​of a list to make a gauge for each of them separately

ie if the list has 4 values​​, one gauge for each one of them with something like:

== Sum ({<store = i >} Sales)

thanks

[Gysbert_Wassenaar]

Close, sum({<store = {'Store A'}>} Sales) would sum the sales for Store A (assuming you have one with that value in the store field). If the values in your store field are numbers then you can use for example sum({<store = {2}>} Sales) to get the sum of sales for store 2. Note, you can't use store both in the set analysis expression and as dimension in the same chart. The sets are calculated in per chart, not per row.

[#3]

yes but as I have to do n gauges want "STORE A" is a variable that takes a value from the list for each guage and so to copy n gauges

[Gysbert_Wassenaar]

Sorry, but I totally do not understand anymore what you want. Please read these two documents:

• QlikCommunity Tip: How to get answers to your post?
• Preparing examples for Upload - Reduction and Data Scrambling.

I'd like to help, but you'll to explain to me what you want. Perhaps you can create an example in Excel that shows the data you use and what the end result should look like.

[#5]

as you see, there are 4 stores and I have to make a gauge for each

and the solution would be to {"store1"} could be replaced with something like stores  for which then could copy without having to touch the properties of gauge (expressions, title, max, min, etc)

[Gysbert_Wassenaar]

You can create one gauge chart, add store as dimension and enable the trellis option on the Dimensions tab. You'll have to play around a bit with the columns and rows option on the trellis dialog window to get a layout that works for you. The expression for the chart will be sum(value). However all the gauges will have the same min and max since they're all part of one chart.

If you want separate charts then you must customize each chart separately too. Chart objects are independent of each other.

[#7]

and there is a function that the elements of a list? Non preocuparese of value, something like this stores (i), if I have to put stores (1) stores (2), etc. in each gauge

thanks

[Gysbert_Wassenaar · Accepted solution]

fieldvalue('store', 1)

fieldvalue('store', 2)

fieldvalue('store', 3)

fieldvalue('store', 4)