topic How to move Text Boxes Dynamically in Qlikview in QlikView

How to move Text Boxes Dynamically in Qlikview

Alex78 — Sat, 16 Nov 2024 04:39:23 GMT

Hi all,

I have a QV application that have several text boxes with triggers to activate (or go to) another sheet when selected. The tabs are going to replace the function of the application Sheet Tabs, i.e., tabrows will be hidden from document properties.

Based on users access, the Sheets as well these Text Box based tabs will be active or hidden; and aligned left. Look at the three images for three different users accessing the document. Img 1: General Tabs layoutImg 2 User A Tabs layoutImg 3: User B Tabs layout

based on the images above, User A will see Tabs 1,3 and 4. Tab 2 as well Sheet 2 will be hidden from User A. Tab 3 and Tab 4 will be aligned left. The same with User B.

Thank you in advance

Alex

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Fri, 25 Jan 2019 21:44:54 GMT

You might be able to create and align your textboxes with some of the macro functionality found in QlikView, someone other than me should guide you if it is possible.

An alternative to re-aligning textboxes based on access is to dynamicly generate the header and activation of a text box.

User A

Box1 = 'Tab1'; Box2 = 'Tab3';Box3='Tab4'; Box4=<hidden>

User B

Box1='Tab2';Box2='Tab4';Box3=<hidden>;Box4=<hidden>

With this solution the textboxes wont need to move around, but you do still get the same look and functionality for the end user. Its probably a bit of fiddeling to do it, but it should be totally doable.

Re: How to move Text Boxes Dynamically in Qlikview

Alex78 — Mon, 28 Jan 2019 14:00:50 GMT

Thank you Vegar,
Can you elaborate the logic you indicated or give me an example?

Thank you

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Mon, 28 Jan 2019 15:02:07 GMT

Try this qvw file.

Laborate and reload the load script filter "Access" for different user scenarios.

LOAD * Inline [
Sheet, Header, Access
SH01, Main sheet,1
SH02, Sheet no1, 1
SH03, Sheet no2, 0
SH04, Sheet no3, 1
]
WHere Access = 1
;

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Mon, 28 Jan 2019 16:02:51 GMT

@Alex78 You could of course apply this logic to the sheets its self if you would like to avoid the extra textboxes

Re: How to move Text Boxes Dynamically in Qlikview

Alex78 — Tue, 29 Jan 2019 14:16:16 GMT

Thank you Vegar.
It is working.

Thank you!!

Re: How to move Text Boxes Dynamically in Qlikview

Alex78 — Tue, 29 Jan 2019 18:42:43 GMT

Hi @Vegar, all the test went well and worked great. But when I deploy it to QMC and reload, noting is returned for every FirstField() function.
Any idea?

Thank you

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Tue, 29 Jan 2019 19:49:25 GMT

Are you reducing the available field values with section access? If so, make sure that you do have available field values in the published version.

Re: How to move Text Boxes Dynamically in Qlikview

Alex78 — Wed, 30 Jan 2019 02:35:40 GMT

Thank you for coming back on this @Vegar,

Yes, I am using section access to reduce data.

What I do on my document is when I use OSUser() function to filter the user Sheet access in the script, it returns as intended on QV Desktop with the Text Box Tabs required to be hidden/visible as planned. Once deployed, it returns nothing or all the Text Box Tabs are hidden for the user. However, if I hard code the user in the script filter, it works as intended both on desktop and after deployed to server.

Based on your sample qvw, I added the User Login on the load as follows.

LOAD * Inline [
Sheet, Header, Access, UserLogin
SH01, Main sheet,1, Domain\User01
SH02, Sheet no1, 1, Domain\User01
SH03, Sheet no2, 0, Domain\User01
SH04, Sheet no3, 1, Domain\User01

SH01, Main sheet,0, Domain\User002
SH02, Sheet no1, 1, Domain\User002
SH03, Sheet no2, 1, Domain\User002
SH04, Sheet no3, 0, Domain\User002
]
Where Access = 1
AND UserLogin = 'Domain\User002';

==> this returns SH02 and SH03 Tabs active and aligned left, with the header and sheet triggers set as intended.

But with the following it does not work

LOAD * Inline [
Sheet, Header, Access, UserLogin

...... same as above

]

Where Access = 1
AND UserLogin = OSUser();

==> Hides all the Text Box Tabs. I tested the values of the field with text boxes and returns nothing both for the header and sheet.

I also tested the application on desktop and server with and without section access and is behaving same.

Thank you for the help.

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Wed, 30 Jan 2019 08:55:33 GMT

WHERE UserLogin = OSUser()

If you use OSUser() in the script you only get the OSUser for the user executing the script, not dynamicly for each user using the application. When running in QMC the OSUser() will we your service account.

You need to use Section Access or Reduce data the distribution if you have a QlikView Publisher.

See attached qwv with an simple SA implementation.

USERID, PASSWORD, SHEETACCESS
ADMIN, 123, 	  *
USER1, 123, 	  SH01|SH03  
USER2, 123, 	  SH01|SH02
USER3, 123, 	  SH03
USER4, 123, 	  SH01|SH02|SH03|SH04

Re: How to move Text Boxes Dynamically in Qlikview

Alex78 — Thu, 31 Jan 2019 09:18:27 GMT

Hi and thank you again @Vegar,

I am still experiencing the same output where once the document is published the Tab Text boxes show the right header and triggers work as intended. However, the Tab Text boxes are not dynamically aligned to the left; like

If User01 (set to view all tabs) -- no issue

Tab1 Tab2 Tab3 Tab4 -- all tabs are arranged and headers are in order

User002 (if set to see only Tab1 and Tab 4) will view the two tabs but leaves space (of Tab2 and Tab3 in between)

Tab1 Tab4 -- the two tabs with their header appearing far apart

It is puzzling that with everything the same but add a filter with a hard code UserLogin = 'Domain\User002' in the script and run it in Publisher, everything is aligned for the user.

Any idea on this?

Thanks!

Re: How to move Text Boxes Dynamically in Qlikview

Vegar — Thu, 31 Jan 2019 09:56:15 GMT

I don't think you have copied my example correctly. In my example app it looks like in the picure below. (In this attachment I've even put show conditions to the actual document tabs as well. )

The view of three diffrent users with different Section Access

Section Access;
LOAD ACCESS, USERID, PASSWORD
INLINE [
    ACCESS, USERID, PASSWORD
    ADMIN, 	ADMIN, 	123, 	
    USER, 	USER01, 123
    USER, 	USER002,123
	];

LOAD * Inline [
	SHEETACCESS, 	USERID
	SH01, 			USER01
	SH02, 			USER01
	SH04,  			USER01 
	SH01, 			ADMIN
	SH02, 			ADMIN
	SH03,  			ADMIN
	SH04,  			ADMIN
	SH02,  			USER002
	SH03,  			USER002
	]
;


Section Application;
LOAD 	
	UPPER(Sheet) as SHEETACCESS, 
	* 
Inline [
Sheet, Header
SH01, Main sheet
SH02, Sheet no1
SH03, Sheet no2
SH04, Sheet no3
];