topic Re: using a left in set analysis in QlikView

using a left in set analysis

samuel_brierley — Wed, 15 Jan 2014 11:42:03 GMT

Can anyone see a problem with the below formula?

sum{$<left(OverHeads,7) = {"SICKNESS"} >} [Total Hours])

maxgro — Wed, 15 Jan 2014 11:50:53 GMT

try this

=sum({$ <OverHeads={"SICKNESS*"}>} [Total Hours])

SICKNESS length is 8

kiranmanoharrode — Wed, 15 Jan 2014 11:54:25 GMT

Try this...........

=if(left(OverHeads,7) = 'SICKNESS',Sum([Total Hours]))

nizamsha — Wed, 15 Jan 2014 12:00:52 GMT

if(

WildMatch(Subtitle,'ABC*'),Left(Subtitle,5),sum(value))

Clever_Anjos — Wed, 15 Jan 2014 12:02:52 GMT

You can´t use a function to modify a field name.

Possible workarounds:

1) Create a field at script level left(OverHeads,7) as filterfield

2) Using "if" as Kiran proposes

3) Using "*" modifier as Massimo proposes

samuel_brierley — Wed, 15 Jan 2014 12:07:02 GMT

thank you thats got it