topic Re: Qlikview set analysis filter based on multiple fields in QlikView

Qlikview set analysis filter based on multiple fields

Wed, 19 Nov 2014 21:43:40 GMT

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!

Re: Qlikview set analysis filter based on multiple fields

JonnyPoole — Wed, 19 Nov 2014 21:52:11 GMT

I was testing this and the space between the " and the > matters.

Change:

sum({1< [perc] = {" >=0.9"} >} [ap] )

sum({1< [perc] = {">=0.9"}>}

Re: Qlikview set analysis filter based on multiple fields

Wed, 19 Nov 2014 22:08:18 GMT

WOW! good catch, I am used to putting spaces in for formatting. I haven't figured out how to get it to work with the full expression but it's likely something along the same lines. Thanks so much!

Re: Qlikview set analysis filter based on multiple fields

JonnyPoole — Thu, 20 Nov 2014 14:42:01 GMT

Super. If its working now kindly mark helpful/correct answers and close the thread. It helps others find solutions to similar questions.