Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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)

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Got it....had to remove FISYR

View solution in original post

1 Reply
Highlighted
Specialist
Specialist

Got it....had to remove FISYR

View solution in original post