Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Text Box Calculation based on a chart value

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.

4 Replies
MVP
MVP

Re: Text Box Calculation based on a chart value

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?

Not applicable

Re: Text Box Calculation based on a chart value

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.

Highlighted
MVP
MVP

Re: Text Box Calculation based on a chart value

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.

Not applicable

Re: Text Box Calculation based on a chart value

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