Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

helen_pip
Contributor II

Message Box - For users without access to a sheet

Hello

I have a front page in my qikview document.   On this front pages are buttons which users can use to go further into the document depending on what they want to see and their access rights

I have set up restrictions in my script which does not allow certain pages: Script is below

 

 

SECTION ACCESS;

LOAD * INLINE [

    ACCESS, USERID, LEVEL

    USER, 1, DETAIL

    USER, 2,NO_DETAIL

    ADMIN, 3, DETAIL

];

Section Application;

LOAD * INLINE [

    LEVEL,VALID

    DETAIL, 1

    NO_DETAIL,0

];

And then in the Conditional Show:  sum(VALID)>0

I now want a message (Text Box) to pop up when the user presses the button on the front page of the document telling them something like "You do not have access to this page at this time"

Can anyone help me achieve this?

Thanks

Helen

6 Replies
er_mohit
Honored Contributor II

Re: Message Box - For users without access to a sheet

this can be done using macro.. you should have to active the document in that condition

helen_pip
Contributor II

Re: Message Box - For users without access to a sheet

Hello,

Thank you for your response

Do you have an example.....I have not performed a macro yet?  Have you dones something similar in the past?

Thanks

Helen

er_mohit
Honored Contributor II

Re: Message Box - For users without access to a sheet

not like this application but i used macro for the purpose of user end duplicate value. if he tried to enter same value then it gives pop up msg.

your problem also solved i attached you vb script manual might be helpful for you.

Not applicable

Re: Message Box - For users without access to a sheet

I am interested in this question. Sounds like some VBA with messagebox control can do it. However, I am not quite familiar with the VBA part. With regard to some use of messagebox, reading some tutorials is recommended. The idea above offered is nice. Hope more ideas can be put out.

joaquinlr
Valued Contributor II

Re: Message Box - For users without access to a sheet

Hi Helen:

You should try an alert, in the menu bar choose tools, after alerts; the condition must be sum(VALID)>0

There is also an Alert Wizard.

When somebody opens the doc him/her will see your message alert.

Hope it helps you.

Joaquín

joaquinlr
Valued Contributor II

Re: Message Box - For users without access to a sheet

Hi Helen:

This is a macro sample:

Sub MessageBox

  Text = "Test message for a sample"

  Return = MsgBox (Text, vbInformation)

End sub

Community Browser