8 Replies Latest reply on Dec 13, 2016 11:09 PM by Christian Mischak

    Filtering with IF: Excel works / Tableau doesnt show?!

    Christian Mischak

      Hi!

       

      sorry but I have another question.

       

      I wanted to filter multiple rows to get a Display of them or to hide them depending of all filter IFs do fit or not.

       

      the Filter Code would be::

       

      if [A] !=null and [B] !=null and ........ then "Show" else "hide" end

       

       

      But I always get hide. Regardless how long the chain is.

      Is there something I have to do regarding dimensions, continious, discrete, etc ???

       

       

       

       

      Excel Displays it correctly when I do and sort it with  i.e. MAX AMOUNT

       

      I also tried using the separate fields of the chain but basically some Problem here

       

       

      THANKS A LOT!