topic Text object if statement problems in QlikView

Text object if statement problems

Tue, 05 Aug 2014 18:15:18 GMT

Dear Community,

The expression below is listed as okay, but displays an AccountValue of $0.00 for the bottom line for the last few years. It should display Account Values going back, but I'd like it to display December's AccountValue total.

Is there any reason you can quickly see that it would mess up like this? The top line is fine. I'm guessing it has to do with the inequality.

(year(Today()),money(sum({$<[Marketing Qualified]=,PrimaryAdvisor.AdvisorFullName=,MonthNumber={$(=If(Year(Today())=(FilteredYear),Max(Month(AccountValue.AsOfDate))))}>}AccountValue.AccountValue)),

If(Year(Date)>Year(Today()),money(sum({$<[Marketing Qualified]=,PrimaryAdvisor.AdvisorFullName=,MonthNumber={'12'}>}AccountValue.AccountValue))))

Thanks,

Ben

Re: Text object if statement problems

Tue, 05 Aug 2014 18:22:45 GMT

Ben,

What are you trying to do with the section of the set analysis with:

(sum({$<[Marketing Qualified]=,PrimaryAdvisor.AdvisorFullName=,MonthNumber={'12'}>}AccountValue.AccountValue)

you don't specify values you're filtering your set on for Marketing Qualified, or Advisor Full Name

Re: Text object if statement problems

Tue, 05 Aug 2014 18:29:20 GMT

Robert,

Right--those are ignoring other listboxes on the dashboard I have (the listboxes ignored being Marketing Qualified and PrimaryAdvisor.AdvisorFullName). Thanks!

Ben

Re: Text object if statement problems

Tue, 05 Aug 2014 19:36:04 GMT

Found it--the two inequalities interfered with each other, I needed to make sure that the top if statement didn't overlap with the bottom one.