topic Re: macro on button in QlikView

macro on button

Fri, 22 Jul 2016 08:31:24 GMT

hi , am new to qlik view

i have 2 variables F_date and T_date

if F_date is more than T_date have to display the error message

how to do please help me

by using macro vb script

Re: macro on button

Fri, 22 Jul 2016 09:03:37 GMT

Is this ok?

Re: macro on button

chrisg — Fri, 22 Jul 2016 09:05:45 GMT

Hi Hari,

i do not think it is necessary to control the via a macro. You could put a variable via a trigger and then display a box on a condition. Can you privdeus a little more informations

Best regards

Christoph

Re: macro on button

Fri, 22 Jul 2016 09:24:32 GMT

hi chrisg

my requirement is like that only

how to retreive variable data from qv tomacro

Re: macro on button

susovan — Fri, 22 Jul 2016 09:26:01 GMT

Hi Hari,

Please find the attachment.

Its might be work,

Re: macro on button

anagharao — Fri, 22 Jul 2016 09:32:21 GMT

Hi,

You could use the below VB script for an action in a button:

Public Sub CheckDate()

Set FDate = ActiveDocument.Variables("F_date")

Set TDate = ActiveDocument.Variables("T_date")

IF FDate.GetContent.String > TDate.GetContent.String Then

Msgbox("Error Message")

End if

End Sub

You could use variables to do the same without using any VB script.

Re: macro on button

Fri, 22 Jul 2016 09:36:33 GMT

thank you so much susovan.g

Re: macro on button

Fri, 22 Jul 2016 09:43:20 GMT

THANK YOU SO MUCH anagharao

Re: macro on button

awhitfield — Fri, 22 Jul 2016 09:46:25 GMT

Hi Hari,

You can do this really easily without using a macro, just use a text box with a conditional hide / show.

See the example attached, which just uses:

To make the error visible when Variable1 is more than Variable2

Andy

Re: macro on button

Fri, 22 Jul 2016 09:51:35 GMT

hi awhitfield

this one is done but my boss not accepted

thank you awhitfield