Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. 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
Highlighted
Master
Master

Re: Sum invers set analysis selecct dimesion

Here you go.

 

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

Highlighted
Creator II
Creator II

Re: Sum invers set analysis selecct dimesion

Hi

you can try too:

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

 

Regards

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