topic Re: expression help in QlikView

expression help

Mon, 27 Apr 2015 11:18:39 GMT

Hi,

This will be a simple I guess so apologies if it's rather basic.

With have a field in some data called 'responded to'. The possible answers are 'Y' and 'N' which have been populated in the fields.

On our app we want 2 charts - once showing breakdown of 'Y' by area and the other 'N' by area. The answer is an expression in the chart but we can't seem to get it right.

Can someone please help? Below is the expression we have. Its says its ok but its not reflecting the data.

Count([Responded to letter?] = 'Y')

Chris

Re: expression help

priyarane — Mon, 27 Apr 2015 11:21:31 GMT

Count({<Respondtoletter = {'Y'}>})Field)

Re: expression help

Mon, 27 Apr 2015 11:39:32 GMT

Where you have 'Field' do we put something in there to replace that?

Re: expression help

priyarane — Mon, 27 Apr 2015 11:58:57 GMT

So, what ever your counting.

For Ex:

Count for country

then Count(Country)

Re: expression help

awhitfield — Mon, 27 Apr 2015 12:01:21 GMT

HI Chris

=Count({<RespondedToLetter={Y}>}RespondedToLetter)

so you are counting the number of RespondedtoLetter where the value of that field = Y

Cheers

Andy

Re: expression help

Mon, 27 Apr 2015 12:06:05 GMT

Hi,

Try this,

IF(Responded to letter?] = 'Y',COUNT('Y'),COUNT('N')

Rgds,

Priyantha.