presentation problem

[#1]

Hi, is there a way to give links or buttons to access sheets in qlikview? or when we are doing a presentation using qlikview application, can we setup the application to change the sheets on mouse click or something

[jagan · Accepted solution]

Hi Dushan,

Create a button -> Properties -> Triggers - > Actions -> Add -> Layout -> Activate Sheet and give the sheet name.

Please find attached file for solution.

Regards,

Jagan.

[#3]

thanks jagan. can u explain this set analysis part to me.

Num(SUM({<month=,  year=, Date={'>=$(=YearStart(Today(), -1, 4))<=$(=AddMonths(Today()-16, -12))'}>}saleVal),'#,##0')

i had to change it like this to get my actual figures

Num(SUM({<month=,  year=, Date={'>=$(=YearStart(Today()-16, -1, 4))<=$(=AddMonths(Today()-16, -13))'}>}saleVal),'#,##0')

thanks again

[jagan]

Hi,

Date={'>=$(=YearStart(Today(), -1, 4)) - This will give you the Previous financial year start date i.e., 1-APR-2012

AddMonths(Today()-16, -12)- This will give you the 3-MAR-2014 (If we check for today)

month=,  year=, - Excludes the Year and month selection.

Sum({<>} saleVal) - will give you the Sales values for the above period.

Hope this helps you.  Please close this thread by giving Correct and Helpful answers to the posts if you are done with your task.

Regards,

jagan.

[#5]

Thanks jagan