Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Categorize Dimensions based on Expression Values

Hi Friends!

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 -

COMPANYDISTRICTDATESALES
XA05/07/1880
XA04/07/1830
XA03/07/1860
XB02/07/1870
XB01/07/1820
XB30/06/18100
XC29/06/1840
XC28/06/1830
XC27/06/1880
YA05/07/1840
YA04/07/1830
YA03/07/18100
YB02/07/1810
YB01/07/1870
YB30/06/1840
YC29/06/1820
YC28/06/1870
YC27/06/1870

Appreciate the help guys!


Thanks,

Aditya

5 Replies
Highlighted
MVP
MVP

Try list box expression, like:

=If(Aggr(Sum(SALES), DISTRICT)>150, 'Relevant', 'Non-Relevant')

Partner
Partner

Hi,

Try attached file

Saludos

Highlighted
Contributor III
Contributor III

Thanks Tresesco for the ultra fast reply! Worked like a charm.........

Highlighted
Contributor III
Contributor III

Hi Federico! I think the attachment is missed...

Highlighted
Partner
Partner

Try now