3 Replies Latest reply: Nov 20, 2014 9:42 AM by Jonathan Poole RSS

    Qlikview set analysis filter based on multiple fields

      I am fairly new to Qlik (not to programming) and trying to get the following to work:


      sum({1< [perc] = {" >= 0.9"}, [ap] = {"fabs([ap]) >10000"}, [flag] = {"NO"} >}[ap])


      I have tried with just [perc] = {" >= 0.9"} and without the '1' before the < and there is no data to display.  However I know that there is.  Have I got the expression wrong?


      In Pandas-I would possibly need to tell it what 0.9 or 10000 or NO are, by changing the data type to number or integer or string...-could this be the problem?


      Thanks for any help! Much appreciated!