Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

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?

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

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.

Community Browser