Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

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

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

3 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator II
Creator II
Author

Thanks for the help.  I will be there!

Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP