Straight table help

danielnevitt — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Straight table help

sunny_talwar — Thu, 29 Jun 2017 15:23:52 GMT

May be like this

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

topic Re: Straight table help in QlikView

Straight table help

Re: Straight table help