Expressions in Chart Properties

[#1]

Hello,

I have a CheckYN flag Expression in a Straight Table chart. This flag compares two date fields (the date fields are being pulled in from two different tables) and assigning a "Yes" or a "No". This part works fine. Now, I only want to see the "Yes" records in my application. This part is not working.

How can I get just the "Yes" items to show? I've tried using the Presentation tab, selecting my Expression name (CheckYN Flag) and selecting the Conditional setting and in the conditional putting the formula: ='Yes' but that does not work. Am I simply using the wrong syntax for the formula or is there something else I need to do?

Any help would be greatly appreciated! Thanks.

nmellick

[pover]

The conditional setting in the presentations tab for showing or hiding the whole column. In order to not show certain rows you have to go to the expressions tab and for every expression put the condition, if([CheckYN Flag]='Yes', "Expression", null()). In that way the rows with the CheckYN Flag as No will return null and in QlikView rows will null values are hidden by default.

Regards.

[#3]

Thanks Karl for the response. I'm not quite sure where to go and put this condition in every expression. Do I put it in the "Show value" section of each one?

nmellick

[johnw]

You actually change every expression. If one of your expressions is this:

sum(Sales)

Then you would change the expression to this instead:

if([CheckYN Flag]='Yes', sum(Sales))