Can Expression be given in " Open QlikView Document" under Action tab?

[#1]

Hi All,

I want to open a new file on the click of a button and my file names are Aug-12, Sept-12, Oct-12 etc etc.

Now I have a field(Month) wherein the only value is Nov-12. Can i use =date(addmonths(Month, -1),'MMM-YY))&'.qvw' to open a file named Oct-12.qvw

I tried multiple times but everytime a pop up comes saying "Failed to Open Document"

Please do help me in this

Regards

Sagar Gupta

[#2]

Sagar,

You are almost there. Try using this:

=date(addmonths(Month, -1),'MMM-YY')&'.qvw' in Actions - Open QlikView Document field.

However, you must ensure that both the file you are working on (Nov-12, in this case) and (Oct-12) must be in the same directory. Even if otherwise, you can concatenate the path of the QVW directory into the Action statement to make it work and it would be something like this:

='C:\Users\Developer\Desktop\'&date(addmonths(Month, -1),'MMM-YY')&'.qvw'

Hope that helps.

Regards,

-Khaled.

[#3]

Ya you are right, actually it was my mistake. I gave the file nane Sept-12 and in the expression it was throughing the value Sep-12 🙂

Anyways thanks a lot for reply

Regards

Sagar Gupta