topic Re: show total without selections pie chart in QlikView

show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 16:30:11 GMT

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!

Re: show total without selections pie chart

sunny_talwar — Mon, 25 Apr 2016 16:37:32 GMT

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

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 16:59:01 GMT

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!

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 19:02:41 GMT

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

Re: show total without selections pie chart

sunny_talwar — Mon, 25 Apr 2016 19:05:28 GMT

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?

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 19:09:27 GMT

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

Re: show total without selections pie chart

sunny_talwar — Mon, 25 Apr 2016 19:11:05 GMT

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?

Re: show total without selections pie chart

sunny_talwar — Mon, 25 Apr 2016 19:12:57 GMT

Is it 112?

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 19:15:29 GMT

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

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 19:15:58 GMT

Yes...

Re: show total without selections pie chart

sunny_talwar — Mon, 25 Apr 2016 19:25:39 GMT

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

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

Re: show total without selections pie chart

pgalvezt — Mon, 25 Apr 2016 19:41:32 GMT

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