Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Set summary to zero when no selection applied

Hi,

I have a chart object that totals the current aged debt of a customer(s) when one (or more) are selected (filtered) but when no customer is selected the total aged debt for all records in the data set is displayed.

Is there a away to  display zero when no customer is selected?

I'll continue to research but if someone knows the answer please tell.

Thanks,
Roger

1 Solution

Accepted Solutions
Highlighted
Champion II
Champion II

Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))

or

if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)

View solution in original post

4 Replies
Highlighted
Contributor II
Contributor II

Hi All,

Problem solved.

For those that need to know the following limits the totaling to 1 filter value.

     if (Count(Distinct account_ref) > 1,0, Sum(AGED_CURRENT))

I still think there must be a cleaner solution but can't find it (yet).

Roger

Highlighted
Champion II
Champion II

Sum(if(GetSelectedCount(account_ref),AGED_CURRENT))

or

if(GetSelectedCount(account_ref),sum(AGED_CURRENT),0)

View solution in original post

Highlighted
Contributor II
Contributor II

Hi Vineeth,

Thanks for the response, both work perfectly thank you.

I knew there had to be an existing variable but just couldn't find it.

Highlighted
Champion II
Champion II

Glad to help

Cheers

V