Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BuminK
Contributor
Contributor

Filter at set analysis

I have the following Table

1 EB
100 Stammkapital
0143 immaterielle Vermögensgegenstände
0520 Pkw
0635 Betriebs- und Geschäftsausstattung
0650 Büroeinrichtung
0755 Gewinnvortrag vor Verwendung
0850 Beteiligungen
1000 Verrechnungskonto Anlagevermögen
1010 Anlagevermögen
1050 Beteiligungen
1100 Verbindlichkeiten langfristig
1200 Kunden gewerblich Inland
1210 Kunden gewerblich EU
1220 Kunden gewerblich Drittland
4000 Kosten
8000 Umsatz

 

in a set analyses formula i want to select only all codes less than 4000 Kosten

Sum({$ <Jahr = {"$(=only(Jahr)-1)"}, Monat = {"*"}, Konto = {"< 4000"} >} [Betrag])

what is wrong with this formula?

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer

It needs only a numeric field Konto to apply a <= >= comparison. Additionally helpful may also be to have further grouping-information to include/exclude areas.

View solution in original post

2 Replies
marcus_sommer

It needs only a numeric field Konto to apply a <= >= comparison. Additionally helpful may also be to have further grouping-information to include/exclude areas.

BuminK
Contributor
Contributor
Author

I have changed the field Konto to mumeric then it worked

 

thanks