Count if or/and

[kodyjameson]

Hello Qlik Wizards,

I'm trying to figure out how to filter a dimension within a bar chart. My current measure formula is below and I'd like to add a Division filter to it as well. 

Count({<CODE = -{null} ,CODE = -{''} , NEW_CODE = CODE , DIVISION = {'FA*'} >} NEW_CODE)

Within the DIVISION field there are multiple values. I only want to show data that falls under divisions that begin with "FA".

Any help is appreciated!

[Zapparoli · Accepted solution]

Hi @kodyjameson 

What you are trying to is called a "Advanced Search" on Qlik, and for that to work, you need to use Double quotes like this:

Count({<CODE = -{null} ,CODE = -{''} , NEW_CODE = CODE , DIVISION = {"FA*"} >} NEW_CODE)

Also check this post that explains more:
https://community.qlik.com/t5/Design/Quotes-in-Set-Analysis/ba-p/1471824

Let me know if this helps.

-Zapparoli

[BrunPierre]

Try.

Count({$<Field = {"=Len(Trim(CODE )) > 0"}, NEW_CODE ={"=NEW_CODE=CODE "}, DIVISION = {"FA*"} >} NEW_CODE)

[kodyjameson]

@Zapparoli Thanks for the quick response! This worked like a charm!