Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
@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.