This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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...