Results of If statement in Drop Down Box

[ccsimo16]

Hi

I have a expression with multiple if statements, which results in, up trading, down trading, lost etc.

Is it possible to have a drop down box with the statements so I can filter out which are up, down or lost or show all when required?

Thanks for your help

Chris

[swuehl]

Have a look at the ad-hoc reports in the 'What's new in QV11.qvw' demo app.

You can create a list box (based on a data island table in your model) that allows the user to select UP, DOWN, LOST, ALL.

Then create an expression for each selectable value in your e.g. table chart and use a conditional to enable / disable the expression based on the selected list box value.

As said, have a look at the sample QVW or search this forum for adhoc reporting, there are plenty of samples.

[ccsimo16]

Thanks Stefan, will give it a go