Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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')

Highlighted
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