topic Re: Categorize Dimensions based on Expression Values in QlikView

Categorize Dimensions based on Expression Values

sonu8072 — Wed, 25 Nov 2020 16:16:04 GMT

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 -

COMPANY	DISTRICT	DATE	SALES
X	A	05/07/18	80
X	A	04/07/18	30
X	A	03/07/18	60
X	B	02/07/18	70
X	B	01/07/18	20
X	B	30/06/18	100
X	C	29/06/18	40
X	C	28/06/18	30
X	C	27/06/18	80
Y	A	05/07/18	40
Y	A	04/07/18	30
Y	A	03/07/18	100
Y	B	02/07/18	10
Y	B	01/07/18	70
Y	B	30/06/18	40
Y	C	29/06/18	20
Y	C	28/06/18	70
Y	C	27/06/18	70

Appreciate the help guys!

Thanks,

Aditya

Re: Categorize Dimensions based on Expression Values

tresB — Thu, 05 Jul 2018 06:51:34 GMT

Try list box expression, like:

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

Re: Categorize Dimensions based on Expression Values

fvelascog72 — Thu, 05 Jul 2018 06:54:58 GMT

Hi,

Try attached file

Saludos

Re: Categorize Dimensions based on Expression Values

sonu8072 — Thu, 05 Jul 2018 09:16:49 GMT

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

Re: Categorize Dimensions based on Expression Values

sonu8072 — Thu, 05 Jul 2018 09:19:07 GMT

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

Re: Categorize Dimensions based on Expression Values

fvelascog72 — Thu, 05 Jul 2018 09:33:29 GMT

Try now