Eliminate

[#1]

I would like to eliminate a specific article in a diagram. What should i write in the scrift to do that?

I know how to do if I only want to show some specifik articles, then I can write for example: Article WHERE Article= 'frakt'. Then I only show the article of frakt. But now I want to eliminate 'frakt*, how do I do that??

New here on this sight...

[rbecher]

Hi Jessica,

you can use a WHERE clause on your SELECT like this:

WHERE article NOT LIKE 'frakt%'

or is this is not working

WHERE substr(article, 1, 5) <> 'frakt'

- Ralf

[#3]

Hello Jessica,

You could use Set Analysis for this purpose. If you write something like

sum( { $ - <Article = {'frakt'} > } Sales )

as your diagram formula and exclude null values, the article 'frakt' will not show up in the chart.

Hope this helps,

Hellmar

[#4]

Hello Jessica,

You could use Set Analysis for this purpose. If you write something like

sum( { $ - <Article = {'frakt'} > } Sales )

as your diagram formula and exclude null values, the article 'frakt' will not show up in the chart.

Hope this helps,

Hellmar

[stephencredmond]

Hi,

If you just want to create a where clause in your script to exclude something then that generally is dependent on your data source.

Something like

WHERE Article NOT LIKE 'frakt%'

or

WHERE Article NOT LIKE 'fract*'

Should work.

If you want to bring all the data into your document and then exclude from a specific chart, you can use Set Analysis.

Stephen