topic Re: How to change sheets automatically in Access point. in QlikView

How to change sheets automatically in Access point.

mohammadkhatimi — Fri, 03 Apr 2015 05:49:21 GMT

Hi everyone,

I want to change sheets automatically in Access point... I am able to do it in my desktop side.

Please suggest any solution which is successfully done.

Regards,

Mohammad

Re: How to change sheets automatically in Access point.

Anonymous — Fri, 03 Apr 2015 05:59:40 GMT

Can you please explain automatically with specific cases with which you want to this sheets to change ?

if would be great if you can put in qvw along with specific cases

Re: How to change sheets automatically in Access point.

mohammadkhatimi — Fri, 03 Apr 2015 06:09:36 GMT

Sheet will be changed after some specific time period.....

For e.g Sheet1 will be changed after 10 sec to Sheet 2.

Hope you understand the requirement.

Regards,

Mohammad

Re: How to change sheets automatically in Access point.

Anonymous — Fri, 03 Apr 2015 06:16:21 GMT

ok yup got it.

you will be opening the document at particular sheet right

say you have got 3 sheets

take down the now() in a variable say vStart

on open event set vActiveSheet=1

vActiveSheet=if(now()-vStart>=10 seconds AND now()-vStart<=20 seconds ,2,3)

you can keep add if statements in case you have more than 3 sheets

and on the sheet properties you can mention condition with the appropriate value of variable vActiveSheet

Re: How to change sheets automatically in Access point.

mohammadkhatimi — Fri, 03 Apr 2015 06:19:50 GMT

Have u tried on access point??

N Share me .qvw...

Regards

Mohammad

Re: How to change sheets automatically in Access point.

Anonymous — Fri, 03 Apr 2015 06:21:18 GMT

i have just given pseudo code, if you have qvw please share will try it

Re: How to change sheets automatically in Access point.

Fri, 03 Apr 2015 06:25:48 GMT

GOTO TRIGGERS ADD ACTIONS SELECT SHEET IDS CLIK OK WILL AUTOMATICALLY CHANGE SHEETS AUTOMATICALLY USING VARIABLES ALSO

Re: How to change sheets automatically in Access point.

Fri, 03 Apr 2015 06:32:01 GMT

using triggers we can automatically change sheets in access point goto sheet propertys triggers add actions select sheet id apply ok close document we can change sheets position.

Re: How to change sheets automatically in Access point.

mohammadkhatimi — Fri, 03 Apr 2015 06:38:09 GMT

PFA...

When u implement any logic kindly check whether its working on access point....

Regards

Mohammad

Re: How to change sheets automatically in Access point.

mohammadkhatimi — Sat, 04 Apr 2015 05:28:42 GMT

Hi...Mahammad

I want to change sheets automatically without any click....and within a specific period of time...

Please help me to solve this problem it little bit urgent...

Regards,

Mohammad

Re: How to change sheets automatically in Access point.

mohammadkhatimi — Thu, 16 Apr 2015 07:20:00 GMT

Guyz is any1 have micros related to this topic????