topic Re: Set Analysis expression using Left function in QlikView

Set Analysis expression using Left function

cliff_clayman — Tue, 15 Aug 2017 20:16:27 GMT

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

Oleg_Troyansky — Tue, 15 Aug 2017 20:25:05 GMT

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

cliff_clayman — Tue, 15 Aug 2017 20:29:06 GMT

Thanks for the help. I will be there!

Re: Set Analysis expression using Left function

Oleg_Troyansky — Tue, 15 Aug 2017 21:28:39 GMT

Great! See you in Boston!