topic Re: Count if or/and in App Development

Count if or/and

kodyjameson — Mon, 21 Aug 2023 16:43:43 GMT

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!

Re: Count if or/and

Zapparoli — Mon, 21 Aug 2023 18:16:16 GMT

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

Re: Count if or/and

BrunPierre — Mon, 21 Aug 2023 18:19:47 GMT

Try.

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

Re: Count if or/and

kodyjameson — Mon, 21 Aug 2023 18:54:48 GMT

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