Set Analysis not removing values

[#1]

Hi,

I'm quite new to Qlikview and trying to do Set Analysis on a report atm. I've the below code in an expression on a straight table. It counts the values and 1 is appearing next to every row that has a Status of C in it, but it's not removing the ones that don't have a status of C. Should it be, or do I need to do something else? Again, complete beginner really, and haven't had much training, so apologies if it's a stupid question.

=count(distinct{<STATUS = {"C"} >} [POLICY_NO] )

[simondachstr]

In rows where Status is not C, do you get null or a numeric value as a result?

[juleshartley]

Is [Policy_No] your only dimension in the table?

[#4]

I get 0 in the cell when it's not C

[#5]

I have Policy No, Status and Main_Mem_No. Then there's about 20 expressions that could be dimensions but I want a horizontal scroll bar in the table.

[ashfaq_haseeb]

hi,

try like this

=count(distinct{<STATUS = {'C'} >} [POLICY_NO] )

Regards

ASHFAQ

[juleshartley]

Have you ticked 'suppress zero values'  in the 'presentation' tab?

[annafuksa1]

Can you send your app ?

[#9]

Your Syntax is correct, the only thing that you might what to check is the field name and value are Case and Space sensitive.

What is your dimension?

Alternatively you can also try the following as your dimension:

If(Status = 'C', <Dimension_Name>, 'Not C')

Regards

RL

[#10]

Nope. Work and confidential information in it.