Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
roberto99
Contributor III
Contributor III

Sum invers set analysis selecct dimesion

Hi, I have a listbox with dimension "Cod_Tienda", it is possible in Set analysis, to do the inverse sum of everything selected

sum({-(Cod_Tienda)=GetFieldSelections ( Cod_Tienda)}Sales)


this not work

thanks

2 Replies
shiveshsingh
Master
Master

Here you go.

 

=Sum({<Cod_Tienda>} Sales)-sum({<Cod_Tienda={"$(=getfieldselections(Cod_Tienda))"}>}Sales)

Yoshidaqlik
Creator II
Creator II

Hi

you can try too:

sum({-<Cod_Tienda={"$(=GetFieldSelections(Cod_Tienda,'","'))"}>} Sales)

 

Regards

YoshidaQlik https://www.youtube.com/channel/UC1I9P8MqCZEhB6Nw3FdSqng