Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
MVP
MVP

Charts

Hi,

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

Regards,

Jagan.

rajni_batra
Valued Contributor

Charts

use max() instead of only()

regards

rajni

Not applicable

Re: Charts

Hi,

Use:

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

hope this hepl you

Regards,

Arun Goel

Community Browser