macro on button

[#1]

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

[#2]

Is this ok?

[chrisg]

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

[#4]

hi chrisg

my requirement is like that  only

how to retreive variable data from qv tomacro

[susovan · Accepted solution]

Hi Hari,

Please find the attachment.

Its might be work,

!

[anagharao]

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.

[#7]

thank you so much susovan.g

[#8]

THANK YOU SO MUCH anagharao

[awhitfield]

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

[#10]

hi awhitfield

this one is done but my boss not accepted

thank you awhitfield