Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
suvechha_b
Creator III
Creator III

Please kindly assist me , how can I indicate correctly on my chart

Hi All ,

Please kindly assist me , how can I achieve the below on my chart ,

For eg ,

if bank ='MFC' and ApprovedReceived_Deal_Indicator='1' then it should indicate 'A' else 'D' inrespective if deal_id .

Capture.PNG

sample model attached.

3 Replies
Frank_Hartmann
Master II
Master II

i guess you need to add deal_id as dimension in your second table

hope this helps

suvechha_b
Creator III
Creator III
Author

Thanks Frank .

But , I don't want to add the deal_id .

Is there no other way to get my requirement , as my requirement is per client not on per deal_id .

Frank_Hartmann
Master II
Master II

=aggr(if(bank='Wesbank' or bank='MFC' and ApprovedReceived_Deal_Indicator ='1','A','D'),deal_id)