Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Text object if statement problems

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

1 Solution

Accepted Solutions
Highlighted
Not applicable

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.


View solution in original post

3 Replies
Highlighted
Not applicable

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

Not applicable

Robert,

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

Ben

Highlighted
Not applicable

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.


View solution in original post