topic Set Analysis help required! in QlikView

Set Analysis help required!

Fri, 05 Feb 2010 12:25:02 GMT

Hi All,

From the attached document i want the Sum(SalValue) of those items where schemes is not NULL or not empty(i,e value should be there). Please look in the document for reference. Please do the required changes in the document!

I think its simple one only hope some one will do the needed changes in the document and will attach it.

To open the document use userid:0010012021, password: c2info99

Regards,

Rikab

Set Analysis help required!

stephencredmond — Fri, 05 Feb 2010 12:48:32 GMT

Should be:

=Sum({< schemes -= {""} >} SalValue)

Stephen

Set Analysis help required!

Fri, 05 Feb 2010 12:52:19 GMT

Hi Rikab,

try to write this formula: sum( {$<schemes -= {''}>} SalValue ). The symbols "-=" mean "Not equal" .

Milda

Set Analysis help required!

Fri, 05 Feb 2010 13:12:54 GMT

Hi Stephen & Milda!

Thanks both of your for your help. I also managed to write the same thing what you have wrote. Though it works it has not manged to ignore the Null/Empty values. Requesting you to let me know how can i ignore that.

Set Analysis help required!

vidyut — Fri, 05 Feb 2010 16:20:33 GMT

Will it not help to just suppress the Null Values for the schemes dimension of the chart after applying this new expression?

Set Analysis help required!

Sat, 06 Feb 2010 06:06:49 GMT

Hi Vidyut!

Yes! It is not helping me. Let me know if you have any other solution. I think it may be blank spaces there instead of null values.

Hope Stephen & Milda! can help me out on this!

Regards,

Rikab

Set Analysis help required!

Oleg_Troyansky — Sun, 07 Feb 2010 21:23:25 GMT

Try the following syntax (replace the field names by your actual names):


sum({$<TextField = {"=len(trim(TextField))>0"}>} Qty )

search condition len(trim(field))>0 will eliminate nulls, empty strings, as well as any number of spaces within the field.

Set Analysis help required!

Mon, 08 Feb 2010 05:20:57 GMT

Hi Oleg Troyansky!

Exactly the one i was looking for. Thanks a lot that works.

By the i wish you could help me out for my post on security access. I am struggling a bit. If you can help then i will send you the link.

Thanks and Regards,

Rikab

Set Analysis help required!

Mon, 08 Feb 2010 06:19:53 GMT

hi boss

please check this expression

sum

( {$<schemes = >} if(isnull(schemes)=0,SalValue ))

Set Analysis help required!

Mon, 08 Feb 2010 06:50:41 GMT

Hi Boss!

I have checked it out. It is not working as expected. This code from Mr. Oleg does the trick! Your script is not ignoring the blank and null string. Anyway thanks for effort!

<pre>sum({$<TextField = {"=len(trim(TextField))>0"}>} Qty )

Regards,

Rikab

Set Analysis help required!

Mon, 08 Feb 2010 07:18:35 GMT

Hi All,

I got different idea now. I want to calculate(count) how many itemname of a mfacname is with scheme. Hope some one can help me out!

Thanks and Regards,

Rikab