Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Master
Master

Here you go.

 

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

Highlighted
Creator II
Creator II

Hi

you can try too:

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

 

Regards

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