topic Re: Set Analysis in QlikView

Set Analysis

BI_Dev — Sat, 16 Nov 2024 04:11:21 GMT

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 ])))

mdmukramali — Wed, 13 Mar 2019 13:18:21 GMT

Hi,

Can you try something like this

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

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

tresB — Wed, 13 Mar 2019 13:21:15 GMT

Try like:

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

BI_Dev — Wed, 13 Mar 2019 13:28:12 GMT

Awesome.Thanks much.