3 Replies Latest reply: Aug 15, 2017 5:28 PM by Oleg Troyansky

# Set Analysis expression using Left function

I am trying to get this expression working using Set Analysis because it renders very slowly if I write it as an If expression.  I can't figure out what the proper syntax is for using the Left function.

sum({<[Period] = {'P1'},[Vendor Type] = {'3PL'}, left([Aging],1)={'d'}>} [LineItems])

left([Aging],1)={'d'} - this is what is not working

• ###### Re: Set Analysis expression using Left function

Hi Cliff,

Set Analysis doesn't allow functions on the left from the equals sign, only field names, So, the right syntax here is:

Aging = {"d*"} - select values in the field Aging that begin with the letter d.

Play with Upper and lower case though, it's working in strange ways...

You can learn advanced Set Analysis techniques from my lecture at the Masters Summit for Qlik - coming to Boston in October!

cheers,

Oleg Troyansky

• ###### Re: Set Analysis expression using Left function

Thanks for the help.  I will be there!

• ###### Re: Set Analysis expression using Left function

Great! See you in Boston!