topic Re: Text Box Calculation based on a chart value in QlikView

Text Box Calculation based on a chart value

Mon, 11 Jan 2016 20:12:05 GMT

Hello,

I was trying to create a textbox based on a chart value which I detached at one point to hold the value constant. I am unable to get the calculated value for the text box based on this constant chart value. Is there anything I am missing or any help regarding this?

Thank you.

Roshni.

Re: Text Box Calculation based on a chart value

sunny_talwar — Mon, 11 Jan 2016 20:30:08 GMT

It is difficult to help you by just looking at the description. May be try this:

Sum(Aggr(YourChartExpression, YourChartDimensions))

If the above doesn't work, would you be able to provide a sample?

Re: Text Box Calculation based on a chart value

Mon, 11 Jan 2016 20:57:45 GMT

I have now got the values in the shipped Qty Chart which I am freezing as in Detaching using a macro to remain constant.

The text box currently has only the formula same as the chart ( To show the sum of the shipped Qty in this case). The text box does not show me the same number which I froze previous,

Did I make sense?

Thanks,

Roshni.

Re: Text Box Calculation based on a chart value

sunny_talwar — Mon, 11 Jan 2016 21:47:33 GMT

I see 5 text boxes in total and I am not sure which two you are talking about. Can you try to be more specific please.

Re: Text Box Calculation based on a chart value

Tue, 12 Jan 2016 16:32:55 GMT

Only the PPM box is a text box. the LED display is a chart.