topic Set Analysis - I'm going mad ...... in QlikView

Set Analysis - I'm going mad ......

Fri, 03 Feb 2012 10:27:37 GMT

Hello everybody,

in the past this forum helps we with a complex set analysis formel. But just I need, in my opinion, a simple one.

I have think, that I can create the formel by myself, but it doesn't work...

I have created a field, that compute a sum from 2 other database fields. Just now I like to check this new field

if the result is greate 0. If so, I like to have a sum from another database field.

I have try it with this formel but it doesn't work:

=sum({$<[OffeneAufträge.Offene Menge] = {'>(0)'}>} OffeneAufträge.Auftragswert)

Can anybody give me a hint, please?

Thank you

Set Analysis - I'm going mad ......

swuehl — Fri, 03 Feb 2012 10:36:43 GMT

It probably depends on how your Offene Menge is related to Auftragswert, but I think you should try a search expression using double quotes:

=sum({$<[OffeneAufträge.Offene Menge] = {">0"}>} OffeneAufträge.Auftragswert)

Set Analysis - I'm going mad ......

Fri, 03 Feb 2012 10:40:58 GMT

@swuehl

This is a variation from the formel that I have testet in the past. It don't work...

thank you for your idea...

Set Analysis - I'm going mad ......

swuehl — Fri, 03 Feb 2012 10:52:21 GMT

Would be good if you could describe your data model a bit in detail.

You can give this a try if you want to check the Offene Menge based on Auftragswert:

=sum({$<OffeneAufträge.Auftragswert = {"=sum([OffeneAufträge.Offene Menge])>0"}>} OffeneAufträge.Auftragswert)

Set Analysis - I'm going mad ......

Fri, 03 Feb 2012 11:46:05 GMT

My data model is in this case a single file in qlikview that stores the whole data that I need.

In this file exists this fields: "delivered quantity" and "order quantity" , Qlikview computes the field "undelivered quantity" ("order quantity" - "delivered quantity"). I like to compute the "undelivered amount". So if the field "undelivered quantity" is > 0 than qlikview should take a sum of the field "order amount".

That what I try to become with the set analysis function.....

Set Analysis - I'm going mad ......

hic — Fri, 03 Feb 2012 12:10:48 GMT

I suggest you use a standard if-function in the script and define the field "undelivered amount" there. Then you do not need set analysis.

Set Analysis - I'm going mad ......

perumal_41 — Fri, 03 Feb 2012 12:14:14 GMT

Hi,

If Possiple Please upload ur Application

Regards,

Perumal A