Where Statement

[#1]

I have created a bar graph but I only want the results shown to be if another variable is greater than 0.

I have looked at other forum discussions about a Where statement but I can't seem to find the actual statement itself in qlikview

This is the current bar graph, so it has all the results from the data but I only want it to include the ones where a third variable is greater than 0.

Thanks

[#2 · Accepted solution]

You should be able to qualify that using set analysis. Something like this:

Sum ({$<Variable={'>0'}>} [Expression Field])

[#3]

Example:

Sum({$<vMonths={'>0'}>}[sales])

Exactly do not know i think it works.

[#4]

Can you post the sample data or sample qvw-Ram

[martynlloyd]

I suggest you look at Show Conditional on the Layout tab

Regards,

Marty.