Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should be able to qualify that using set analysis. Something like this:
Sum ({$<Variable={'>0'}>} [Expression Field])
You should be able to qualify that using set analysis. Something like this:
Sum ({$<Variable={'>0'}>} [Expression Field])
Example:
Sum({$<vMonths={'>0'}>}[sales])
Exactly do not know i think it works.
Can you post the sample data or sample qvw-Ram
I suggest you look at Show Conditional on the Layout tab
Regards,
Marty.