Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Specialist
Specialist

Set Analysis ?

I am trying to calculate a percentage based on the year the user selected to current.  I know I am missing something just not sure what.

Thanks

The first line is my current year and the other 2 are suppose to be based on the FISYR the user selects.

(sum({<FISYR = {$(=$(vFisYr) - 0)},[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL]  * 1) -
sum({$<FISYR,[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL]  * 1)) /
sum({$<FISYR,[Expense] = {'E'},YTDFlag = {1}>}[In company code currency_HSL]
  * 1)

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Set Analysis ?

Got it....had to remove FISYR

View solution in original post

1 Reply
Highlighted
Specialist
Specialist

Re: Set Analysis ?

Got it....had to remove FISYR

View solution in original post