topic Re: straight table expression in QlikView

straight table expression

Thu, 13 Feb 2014 09:21:48 GMT

Hi,

We have the following straight table. We also have Compliance as a field with three possible categories: COMPLIANCE, ENFORCEMENT and SUPPORT.

In the table below we would like is to show the count of each category. At the minute showing same one 3 times.

The current expression is Count(Compliance); however, when I've tried to amend to what I think will work If(Compliance)='SUPPORT' I'm not having joy. Please help...

Area	Neighbourhood	Count(Compliance)	Count(Compliance)	Count(Compliance)
Irlam & Cadishead	Moss Vale	490	490	490
Irlam & Cadishead	Falmouth	119	119	119
Irlam & Cadishead	The Glaze	410	410	410

Chris

Re: straight table expression

MK_QSL — Thu, 13 Feb 2014 09:23:23 GMT

Try Something like below..

COUNT({<Compliance = {'SUPPORT'}>}Compliance)

and SO ON.

Re: straight table expression

luis_pimentel — Thu, 13 Feb 2014 09:24:19 GMT

Try

COUNT({<Compliance = {'SUPPORT'}>}Compliance)

Re: straight table expression

Thu, 13 Feb 2014 09:43:53 GMT

Hi Luis, Manish

Thanks..both answers correct but can only mark 1 one of you as correct...

Re: straight table expression

MK_QSL — Thu, 13 Feb 2014 09:51:07 GMT

First Come First Serve