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

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

    Christian Mischak



      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