Set Analysis expression using Left function

[cliff_clayman]

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

[Oleg_Troyansky · Accepted solution]

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

[cliff_clayman]

Thanks for the help.  I will be there!

[Oleg_Troyansky]

Great! See you in Boston!