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

QLIK SENSE distinct count with a sum

I need to output the balance amount only if there is only one currency in the sample. I found a way to output this condition separately for a particular currency:

NUM(Sum({$<[currency]={'810'}>} [currency_balance]), '# ##0,00')

Now I need to make sum output only when filtering is for one currency.

Wawa Customer Survey

Labels (1)
  • Other

1 Reply
sidhiq91
Specialist II
Specialist II

@KimFerguson  Not sure what is your requirement. If I understand correctly, if the user selects any Currency in the Filter Pane, your Sum value should change accordingly? Is  my understanding right?