Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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