Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

6 Replies
MVP
MVP

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

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)

Highlighted
Not applicable

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

@swuehl

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

thank you for your idea...

MVP
MVP

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

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)

Not applicable

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

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.....

Employee
Employee

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

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.

perumal_41
Valued Contributor II

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

Hi,

If Possiple Please upload ur Application

Regards,

Perumal A

Community Browser