Discussion board where members can get started with QlikView.
I have a district wise, date wise database for 2 organizations based on which I wish to create a list box for 'Relevant' & 'Non-Relevant' districts; 'Relevant' being the ones with SALES > 150. Sample data is as below -
Appreciate the help guys!
Try list box expression, like:
=If(Aggr(Sum(SALES), DISTRICT)>150, 'Relevant', 'Non-Relevant')
Try attached file
Thanks Tresesco for the ultra fast reply! Worked like a charm.........
Hi Federico! I think the attachment is missed...