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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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
Partner - Champion III
Partner - Champion III

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