topic Aggregate in textbox with conditions in QlikView

Aggregate in textbox with conditions

sifatnabil — Tue, 23 Sep 2014 01:38:11 GMT

Hi,

I have a straight table chart with

Dimension: TradeID

Expressions:

1. Buyer - concat(Buyer,',')

2. Seller - concat(Seller,',')

3. Trade Type - if(wildmatch(concat(Bank,','),'*Bank X*'), 'VOICE','ELECTRONIC')

How can I express this in a textbox where I want to display the count of VOICE and ELECTRONIC trades?

Thanks for your help.

JonnyPoole — Tue, 23 Sep 2014 02:04:17 GMT

Try this in a list box. I'm putting the 2nd count two lines below the first.

'# Voice Trades: ' & count ( if( wildmatch( Bank, '*Bank X*') , Bank ) )

& chr(10) & chr(10) &

'# Electronic Trades: ' & count( if ( not wildmatch( Bank, '*Bank X*') , Bank) )

rwunderlich — Tue, 23 Sep 2014 02:11:03 GMT

='VOICE: ' & count({<Bank={'Bank X'}>}TradeID)

='ELECTRONIC: ' & count({<Bank=-{'Bank X'}>}TradeID)

-Rob