Count if Column A = '' and Column B < X

[Firebird1]

I'm sure it's very simple but I'm new to Qlik and coding in general.

I'm trying to figure out how to count the number of occurrences when one column meets a condition, and another column meets a condition- both columns must meet the conditions to be counted.

Example.

Column A = 'Books'

Column B < 25

Count the number of times this occurs.

I've looked everywhere and tried several different things but can't get it to work. Any suggestions are most welcome!

[sidhiq91]

@Firebird1  Please try something like below in your load script editor:

If(Column A = 'Books' and Column B < 25,'1',Null()) as Flag

In the front end you can write the expression something as Count(Flag).

This should give you the expected ouput.

If it does, please like and accept it as a solution.