chart expression filter for all field values

andries_bos — Sat, 16 Nov 2024 21:32:11 GMT

I would like to filter my ' Pivot table' chart's expression output to show the total sum only for the customer listed within a certain other field (all possible values). The amount of the filtered customers could change (after a rebuild), so a fixed list of values for filtering as show in other examples within the community is not an option.

I could solve this at first when adding the field ListOfCustomersToBeFiltered as a dimension and use ' Surpress all values Is Null'.

Disadvantage is that the customers number would also show and I just want to show the totals of these filtered customers list:

I thought it could be solved with an expression that should be like :

= Sum({< MyCustomers = {ListOfCustomersToBeFiltered} >} Weights)

but that does not work. Any suggestions if this is possible in this 'easy' way ?

Re: chart expression filter for all field values

agni_gold — Fri, 25 Jan 2019 12:07:35 GMT

This might help :

https://community.qlik.com/t5/QlikView-App-Development/P-E-and-where-do-you-use-them/td-p/457847

Re: chart expression filter for all field values

andries_bos — Fri, 25 Jan 2019 12:33:30 GMT

I never came across these functions before , but it did the trick ! Thanks !

topic chart expression filter for all field values in QlikView

chart expression filter for all field values

Re: chart expression filter for all field values

Re: chart expression filter for all field values