topic Re: Is it possible to select variable values automatically? in QlikView

Is it possible to select variable values automatically?

Mon, 28 Apr 2014 13:01:00 GMT

Hi,

I have qvw with macro which will send data to user email automatically. All is fine. The qvw contains two variables

VStartDate and vEndDate.

The data used to send every Monday before 12pm to user email. The completed week data will send. I,e Suppose today is Monday. so, the variables VStartDate and vEndDate contains

VStartDate=21/04/2014 and vEndDate= 25/04/2014. Like this I will manually selecting variables values every week.

My question is, Is there any solution that variables set automatic. I,e without my interference the variable should take before weeks dates. why I am asking is I don't want to miss the data any case in my absence.

Can anyone please suggest me this?

Thanks.

Re: Is it possible to select variable values automatically?

ashwanin — Mon, 28 Apr 2014 13:15:40 GMT

Hi Amelia,

What it reflects that your Start date and End date is based on the week start date and end date

So for vStart date you can use use =WeekStart(Date(Today()-1))

and for end date use =WeekEnd(Date(Today()-1))

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 13:32:01 GMT

Thanks. Where I need to give this?

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 13:34:50 GMT

I just gave this in variables values. Is that you mean. If so, is there any macro to use this?

Re: Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 13:44:38 GMT

Set the variables in QlikView and then use something like this code in the Macro:

set v = ActiveDocument.Variables("vQlikViewVariable")

v.SetContent vMacroVariable, true

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 13:50:09 GMT

Thanks.

It's working.

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 13:52:20 GMT

My guess is that you have set v and are using V in the SetContent so I would guess it is a problem of case .... ?

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 13:53:13 GMT

Yes you are right now it's working.

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 14:01:33 GMT

By using batch file I schedule this file to reload manually using Task scheduler. My user can able to receive the email from me through task scheduler, but there is no attached excel file. How can I set the attached file?

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 14:31:33 GMT

Sorry. Again I got a problem If I clear all selections I can able to get last week's data. May I know how to set this please?

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 14:32:23 GMT

Sorry I made the answer as correct earlier. But when I clear all selections in qvw I can not able to see the last weeks data. please help me how to set this?

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 14:38:08 GMT

Please help me. I was really confusing here.

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 14:48:25 GMT

For attachments:

objEmail.To = "username@domain.com" 'Email Recipient

objEmail.From = "REPORTS@domain.com" 'Email Sender

objEmail.Subject = "The name of the report" ' Subject

objEmail.TextBody = "some text in the body of the mail" 'Text of email.

objEmail.AddAttachment "c:\DOC\document1.pdf" 'Attachment to add

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 14:52:16 GMT

What selections are you clearing?

There has been no mention of selections as yet ....

Is this a listbar that has been cleared down? Should the setting on the listbar be "Always Select One Value" as this will ensure that the values cannot be cleared from the listbar as there has to always be 1 value selected.

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 14:53:43 GMT

Thanks. I can not able to get last weeks data. Instead excel file showing all weeks data.

I created variables like below

vStartDate= WeekStart(Date(Today()-1)

vEndDate= WeekEnd(Date(Today()-1)

I made triggers in documents properties as

vStartDate OnChange as ='>='&vStartDate & '<=' & vEndDate

vEndDate OnChange as ='>='&vStartDate & '<=' & vEndDate

Am I doing anything wrong here?

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 15:04:55 GMT

Tricky ... as you are resetting the values and it seems as though you should only be setting your values for vStartDate on reload. I think that they are resetting themselves with the same selection each time.

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 15:05:43 GMT

Is there any way to set this? Please help me.

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 15:08:27 GMT

Yes, I think that you should be able to trigger vStartDate and vEndDate on Reload and not change ....

Re: Is it possible to select variable values automatically?

Mon, 28 Apr 2014 15:09:56 GMT

You mean OnInput?

Re: Is it possible to select variable values automatically?

Roop — Mon, 28 Apr 2014 15:23:52 GMT

On PostReload in document properties