show total without selections pie chart

[pgalvezt]

Hello,

I've trying to show the total Chart Pie But I couldn't figure out ...

The idea is there is no selection in chart and QlikView Shows Total... It is as if clicked.

I attached a test file.

Thanks!

[sunny_talwar · Accepted solution]

Try this:

Expresion:

LOAD * Inline "

Form | TomarExpresion

A | Pick(Max(Expresion), Sum(Hrs.Ord.),Sum(Hrs.Ext.),RangeSum(Sum(Hrs.Ord.),Sum(Hrs.Ext.)))

" (delimiter is '|');

or

Expresion:

LOAD * Inline "

Form | TomarExpresion

A | Pick(Max(N°Expresion), Sum(Hrs.Ord.),Sum(Hrs.Ext.),RangeSum(Sum(Hrs.Ord.),Sum(Hrs.Ext.)))

" (delimiter is '|');

[pgalvezt]

Expresion:

LOAD * Inline "

Form | TomarExpresion

A | Pick(Max(N°Expresion), Sum(Hrs.Ord.),Sum(Hrs.Ext.),RangeSum(Sum(Hrs.Ord.),Sum(Hrs.Ext.)))

" (delimiter is '|');

That Was Thanks!!