Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combining formulae

Hi,

I would like to combine these two formulae.

  1. Count({$<[Revenue]={">0"}>} [Student No])
  2. if(Details='Hockey',[Hockey])

The formula in point 2. Should replace the [Revenue] in the formula in point 1.


Tried,

Count({$<if(Details='Hockey',[Hockey])={">0"}>} [Student No])


Any suggestions are welcome.


Thank you

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Not sure what you're trying to do. Perhaps this is what you're looking for:

Count({$<Details={'Hockey'},[Revenue]={">0"}>} [Student No])


talk is cheap, supply exceeds demand