Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Set Analysis

I want o get the total Expense only if the length of ID is >0 and I ma using the below expression and it is not working.

 

Any help is appreciated. Thank you.

sum(Total(({<[ID]=>} [Annual Expense ])))

Labels (4)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Set Analysis

Try like:

sum(Total{<[ID]={"=Len(ID)>0"}>} [Annual Expense ])

View solution in original post

3 Replies
Highlighted
Specialist III
Specialist III

Re: Set Analysis

Hi,

Can you try something like this

=Sum({<[ID]={'*'}>}Total [Annual Expense ])

Or

=Sum({<[ID]= {"=len(trim([ID])) >=1"}>} Total [Annual Expense ])

 

Highlighted
MVP
MVP

Re: Set Analysis

Try like:

sum(Total{<[ID]={"=Len(ID)>0"}>} [Annual Expense ])

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Set Analysis

Awesome.Thanks much.