topic Re: presentation problem in QlikView

presentation problem

Tue, 18 Mar 2014 01:58:29 GMT

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

Re: presentation problem

jagan — Tue, 18 Mar 2014 04:18:47 GMT

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.

Re: presentation problem

Tue, 18 Mar 2014 04:38:09 GMT

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

Re: presentation problem

jagan — Tue, 18 Mar 2014 05:25:16 GMT

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.

Re: presentation problem

Tue, 18 Mar 2014 09:12:54 GMT

Thanks jagan