0

Multi criteria filter

Hi
I want to make a filter of all German and / or French customers but it only works for one or the other. What's the problem

Michel

8 replies

null
    • Kenreich_Zachary
    • 5 yrs ago
    • Reported - view

    What kind of field are you using?

    • noCodeApp
    • Fabio
    • 5 yrs ago
    • Reported - view

    Hello Michel. If you mean a filter in a views table, it needs a specific syntax. Take a look here:

     

    https://ninoxdb.de/en/manual/tables/views-filtering-values

     

    Fabio

    • michellhemery
    • 5 yrs ago
    • Reported - view

    Thank you fabio but I tried everything it does not work
    German and French
    "German" and "French"
    = "German" and "French"

    Yes filter in a views table

    I also tried with or ..... but nothing

    • noCodeApp
    • Fabio
    • 5 yrs ago
    • Reported - view

    mmhh.. in some cases, filters can not be implemented through the mechanisms described in the Filtering Values section.. In these cases the trick is to define the filter over an additional calculated column:

    Use the function “Show columns…” from the View menu --> drag a formula in the list of visible columns --> in this formula, you can set: 'Customers = "German" or 'Customers' = "France" so that it returns a Yes / No value --> then you can create a filter for this calculated column to “Yes” or “No”.

    P.S.
    Today it will be the Ninox Webinar EN at 6:00 PM. If you can participate you will find useful ideas to improve your DB (and ask questions if you need)
    :)

    https://zoom.us/webinar/register/WN_zoSk2qyNSz6vLRFF1zlakg

     

    Fabio

    • Ninox partner
    • RoSoft_Steven.1
    • 5 yrs ago
    • Reported - view

    Maybe try like in stead of = 

    like "German" and like "French"

    I haven’t test it dough. 

    • Nick
    • 5 yrs ago
    • Reported - view

    Works with "or"...

     

    like "German" or like "French"

    • michellhemery
    • 5 yrs ago
    • Reported - view

    Thank you all. The solution proposed by Steven and Nick works perfectly

    • noCodeApp
    • Fabio
    • 5 yrs ago
    • Reported - view

    Perfect it works, thanks

     

    Fabio

Content aside

  • 5 yrs agoLast active
  • 8Replies
  • 2499Views