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

Charts

Hi Guys

i have used only() function in the chart expression  but i want that when user clear the selection he should be able to see the total data.??????

3 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try using the Aggr() in place of Only().

Regards,

Jagan.

rajni_batra
Specialist
Specialist

use max() instead of only()

regards

rajni

Not applicable
Author

Hi,

Use:

=if(GetPossibleCount(Field)=Count({1}Field), sum(Expression),sum({$<Field={$(=Only(Field))}>}Expression))

hope this hepl you

Regards,

Arun Goel