topic Re: How to use function in Set Analysis in QlikView

How to use function in Set Analysis

kamal_sanguri — Mon, 24 Aug 2015 17:35:19 GMT

Hi Experts,

I want to use a function in Set Analysis.

Something like this.

=sum(<Len(Comments) > {'5'}> CHARGES)

But dont know how to use it correctly.. Any help would be greatly appreciated.

Thanks,

-Kamal

kaushiknsolanki — Mon, 24 Aug 2015 17:37:42 GMT

Hi,

Better you create Len(Comments) as lengthOfComments as new field in script and then use the below set expression.

Sum({<lengthOfComments = {">5"}Charges)

Regards,

Kaushik Solanki

ramoncova06 — Mon, 24 Aug 2015 17:44:57 GMT

I agree with Kaushik in the backend changes

though if you are not able to do that then try with

=sum({< CHARGES = {"=Len(Comments) > 5"} >}CHARGES)

maxgro — Mon, 24 Aug 2015 18:04:59 GMT

small example

script

load

rowno() as Id,

floor(rand()*10) as Id2,

floor(rand()*100) as CHARGES,

99999 + floor(rand()*2) as Comments

AutoGenerate 100;

chart with this expression

sum({$ <Id={"=len(Comments)>5"}>} CHARGES)

you can find more detail here