Solved: show total without selections pie chart - Qlik Community

pgalvezt · ‎2016-04-25

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 · ‎2016-04-25

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 '|');

View solution in original post

sunny_talwar · ‎2016-04-25

Your dimension is not Expression in the pie chart. Not sure what are you expecting to see? Like attached?

pgalvezt · ‎2016-04-25

Hi, Sunny,

Thank you for your reply...

My Dimension is what you see (Is not the expresion) I need to see. 3 and 112. If you clic there...the result appears. But if you dont clic on it = Null. I need to show 3 and 12 (This is Total Without selections)...

Thanks!

pgalvezt · ‎2016-04-25

Is it Possible to do this in QlikView? I've trying to do with conditional setences but still can reach out what I expect...

sunny_talwar · ‎2016-04-25

Your dimension is different then the dimension used in Pick Statement for the pie chart. Not sure what you want to see when nothing is selected?

pgalvezt · ‎2016-04-25

What I want to see is this (Image). When I do Select in any option is easy because QlikView show the values. But When I do nothing I would like to see the total...

sunny_talwar · ‎2016-04-25

I guess this is the part, I don't understand, what is total here? Can you give me a number you are looking to get?

sunny_talwar · ‎2016-04-25

Is it 112?

pgalvezt · ‎2016-04-25

Sure,

As you can see you have Number 3 and 112.... That is the total what I want to show without selections...

112 is the sum (109 + 103) .... You have 3 numbers 109...103 and 112 Last One I want to show in qlikview when nothing to be selected....

pgalvezt · ‎2016-04-25

Yes...