Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis - Total with a specific condition

Hi people,

How Can use the Total keyword using  to calculate a expression in chart but to a specific player? Like that:

=SUM( {<Total> DATE, PLAYER = 1234} Nr_Goals)

Thanks!!!

1 Solution

Accepted Solutions
ahmar811
Creator III
Creator III

may be this

=sum(Total{DATE=,PLAYER={1234}},Nr_Goals)

View solution in original post

7 Replies
sunny_talwar

May be this:

=Sum(TOTAL {<PLAYER = {1234}>} Nr_Goals)

Not applicable
Author

With that I guarantee that I ignore all selections, right?

Anonymous
Not applicable
Author

may be this as well?

=Sum(TOTAL <DATE> {<PLAYER = {1234}>} Nr_Goals)

ahmar811
Creator III
Creator III

may be this

=sum(Total{DATE=,PLAYER={1234}},Nr_Goals)

sunny_talwar

You forgot to add <> signs:

=Sum(Total{<DATE=,PLAYER={1234}>} Nr_Goals)

ahmar811
Creator III
Creator III

sorry my mistake

=sum(Total{<DATE=,PLAYER={1234}>},Nr_Goals)


Anonymous
Not applicable
Author

It will ignore all the selection of Date Field only as you are bypasing it in Set analysis