Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Deltus205
Contributor
Contributor

Werte in Diagramm ausschließen/ Excluding Values

English Version below...

Hallo zusammen, hello everybody,

folgendes Problem: es gibt verschiedene Bestellungen mit einer eineindeutigen Bestellnummer und deren Bestellpositionen hinter denen Artikelnummern sind. Es sollen alle Bestellungen ausgeschlossen werden, die eine bestimmte Artikelnummer enthalten.

Bsp.:

Bestellung  0815 Pos. 1 - Artikel 666
                                   Pos. 2 - Artikel 777

Bestellung 0125 Pos. 1 - Artikel 777
                                  Pos. 2 - Artikel 888

Bestellung 1111 Pos.1 - Artikel 555

Bestellung 9598 Pos.1 - Artikel 777

Alle Bestellungen mit dem Artikel 777 sollen ausgeschlossen werden und Bestellungen ohne diesen weiterhin angezeigt. Die verschiedenen Daten wurden in einem Diagramm als Pivot dargestellt und wenn ich die Funktion

if ( Artikel <> '777', Bestellnummer) angebe, dann bleibt nicht allein Bestellung 1111 stehen, sondern zusätzlich auch 0125 und 0815, weil diese eben Positionen enthalten, die ungleich 777 sind. Wie bekomme ich es hin, die "ganze" Bestellung auszuschließen?

_____________________________________________________________________________

following scenario: there are different orders by customers with a bijective order number. Each order has a different number of positions and each position is connected with an article. I want to exclude orders with a specific article.

for example:

order 0815 Pos. 1 - article 666
                        Pos. 2 - article 777

order 0125 Pos. 1 - article 777
                        Pos. 2 - article 888

order 1111 Pos.1 - article 555

order 9598 Pos.1 - article 777

 Each order with article 777 should be excluded and only orders without this one shall be shown. I show the Data in QV with a Pivottable and already tried the function

if ( article <> '777',  order number). But with this not only order 1111 will be shown, also 0125 and 0815 are listed because they have other positions which deliver "true" for this function. Do you have any other ideas for solving this poblem?

Viele Grüße/Regards
Deltus205

1 Solution

Accepted Solutions
Nicole-Smith

This should work as a dimension:

=aggr(if(count({<article={777}>} total <order> article) = 0, article), order, article)

You need the aggr() with count(total) to check all of the records for a specific order to see if it has the 777 record.  The if statement you previously had is checking line by line, which is why it is showing anything without that record.

View solution in original post

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Probiere mal etwas wie: if(not wildmatch(aggr(concat(Artikel, ','), Bestellung), '*777*'), Bestellung)

- Marcus

Nicole-Smith

This should work as a dimension:

=aggr(if(count({<article={777}>} total <order> article) = 0, article), order, article)

You need the aggr() with count(total) to check all of the records for a specific order to see if it has the 777 record.  The if statement you previously had is checking line by line, which is why it is showing anything without that record.

View solution in original post

Deltus205
Contributor
Contributor

Thank you Nicole! That was the solution I was looking for 🙂