topic Select field Automatically using Macro in QlikView

Select field Automatically using Macro

Thu, 21 Oct 2010 07:18:08 GMT

Hi,

I want to automatically select a field based on the selection of another field.

e.g I have the following field:

Date,

Month Number,

Year

and Fiscal Year.

Month Number and Year corresponds to the Date. e.g if date is '20-Oct-2010' then Month Number is 10 and Year 2010.

Now, I want to select Fiscal year automatically based on the selection of Date.

If Month Number is 10 or 11 or 12 then select Fiscal year as Year + 1 else select Fiscal Year as Year.

I have tried to write a Macro for the above but it does not seem to be working. Can anyone please help me with this?

Also, Is there a way to achieve the same without using the Macros

Please let me know if you need further information.

Regards,

Rohit

Thu, 21 Oct 2010 08:06:53 GMT

Also, where Can I find a Documentation to write a Macro in Qlikview and find some functions and examples

Thanks

Thu, 21 Oct 2010 08:16:08 GMT

Check out the API-guide included in when you install qlikview. If you have v9 you can use triggers instead of macros

suniljain — Thu, 21 Oct 2010 11:20:39 GMT

pls check API Guide . it contain lots of example to implement this types of scenario.

I implemented sames scenarion.by studying API Guide.

API Guide contain lots of functionality