topic Eliminate in QlikView

Eliminate

Mon, 14 Sep 2009 19:37:48 GMT

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...

AW:Eliminate

rbecher — Mon, 14 Sep 2009 19:47:24 GMT

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

Eliminate

Mon, 14 Sep 2009 19:47:51 GMT

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

Eliminate

Mon, 14 Sep 2009 19:47:54 GMT

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

Eliminate

stephencredmond — Mon, 14 Sep 2009 19:52:35 GMT

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%'

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