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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Straight table help

Hi,

I have a table that counts the number of 'buys' in one column and the number of 'sells' in another column.  Is it possible to add a third column that shows where there are both buys and sells?

Count({<Side={'Buy'}>}Side)

=Count({<Side={'Sell'}>}Side)

Thanks,

Daniel

1 Reply
sunny_talwar

May be like this

=If(Count({<Side={'Buy'}>}Side) > 0 and Count({<Side={'Sell'}>}Side), 'Both Buy and Sell')