Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with resize a textbox via macro

Hi everybody,

another question. I am just working on a qlikview tool, that needs to create new textboxes at defined positions.
For that i am using the following macro:

set frame = expressionstextbox.GetFrameDef
pos = frame.Rect
pos.Top = v_expression_position_top * 3.125
pos.Left = v_expression_position_left * 3.125
pos.Height = 251 * 3.125
pos.Width = 41 * 3.125
expressionstextbox.SetFrameDef frame

1. Why do i have to multiply my pixels by 3.125 to get the correct pixel position?
2. It seems to me that there are min and max positions required for creating textboxes and placing them.
When i use Width < 41 Pixels the macro ist creating a textbox with exact 41 pixels. Smaller is not possible.
When i use Height > 154 Pixels the macro ist creating a textbox with exact 154 pixels. Larger is not possible.

Has anyone ever had the same problem? Is there a workaround for creating Textboxes smaller than 41 Pixels or larger than 154 Pixels?
Thanks a lot!

1 Solution

Accepted Solutions
Not applicable
Author

I tried my macro in Qlikview 10 and there everything works fine! It seems to be a problem in Qlikview 9 only.

View solution in original post

2 Replies
Not applicable
Author

I tried my macro in Qlikview 10 and there everything works fine! It seems to be a problem in Qlikview 9 only.

lucas4bi
Partner - Creator
Partner - Creator

I have the same Issue using QV11 SR2. Does anyone know why?

If if multiply for 3.125 it works all fine, otherwise the pixels are completly messed up.