Show amount by only last name

Wed, 24 Jun 2015 19:15:31 GMT

Hi everyone!

I hope you're all doing well, and thanks for taking the time out of your day to answer my question. I have a code that needs to display - when nothing is selected from my master calendar or list box of last names, but needs to display whichever combination's sum. So right now, if I select a last name it displays a - incorrectly. If I select a date period, it shows the sum of that combination correctly. If it I choose a name and a date period it shows the sum of that combination correctly. If I select nothing, it shows - correctly It just won't show the sum of only a name. I've tried linking it by last name, employee ID, and unique ID with no luck. What am I doing wrong?

=money(if(GetFieldSelections(FiscalMonthYear), sum([Approved Amount]),

//if(IsNull(FiscalMonthYear), 'Select Period',

//if(IsNull(FiscalQuarterYear), 'Select Period',

if(GetFieldSelections(FiscalQuarterYear),sum([Approved Amount]),

// if(IsNull(FiscalMonth), 'Select Period',

if(GetFieldSelections(FiscalMonth), sum([Approved Amount]),

if(GetFieldSelections(FiscalQuarter),sum([Approved Amount]),

//if(IsNull(FiscalQuarter), 'Select Period',

if(IsNull([FiscalYear]), '-',

if(GetFieldSelections([FiscalYear]),sum([Approved Amount]),

if(GetFieldSelections([Last Name]), sum([Approved Amount]),

if(GetFieldSelections([Employee ID]), sum([Approved Amount]),

if(GetFieldSelections(EmployeeID), sum([Approved Amount]),

if(GetFieldSelections([Unique ID]), sum([Approved Amount]))))))))))))

Thanks for all your help!

topic Show amount by only last name in QlikView

Show amount by only last name