topic Re: Where Statement in QlikView

Where Statement

Fri, 08 Aug 2014 12:09:32 GMT

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

Re: Where Statement

Fri, 08 Aug 2014 12:16:24 GMT

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

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

Re: Where Statement

Fri, 08 Aug 2014 15:13:06 GMT

Example:

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

Exactly do not know i think it works.

Re: Where Statement

Mon, 18 Aug 2014 13:32:50 GMT

Can you post the sample data or sample qvw-Ram

Re: Where Statement

martynlloyd — Mon, 18 Aug 2014 13:36:50 GMT

I suggest you look at Show Conditional on the Layout tab

Regards,

Marty.