topic Re: Specify Dimension's range of values to ignore one of the lines in QlikView

Specify Dimension's range of values to ignore one of the lines

Tue, 21 Feb 2012 18:43:18 GMT

Requesting help on customizing a line chart. Let's say I have these dimensions and expression:

Dimensions:

-Time

-Product

Expression:

-Price

There's a product called 'Reference' in my data, which is actually used as a reference line in the chart, but it needs to be treated as a product in the data.

I wish to specify my dimensions so that on the X axis, it will show the X values for all products EXCLUDING the reference line.

In other words, I want the X axis to ignore this 'reference line' and plot data within the domain of all other products.

What can I do?

Specify Dimension's range of values to ignore one of the lines

swuehl — Tue, 21 Feb 2012 18:50:12 GMT

I think you could either use

=if(Product <> 'Reference', Product)

as your second, calculated dimension, or use set analysis in your expression, e.g.

sum({<Product -= {Reference}>} Price)

Specify Dimension's range of values to ignore one of the lines

Tue, 21 Feb 2012 19:21:45 GMT

Actually I wanted to keep 'Reference' in the chart.

If I use =if(Product <> 'Reference', Product)

then I will lose the line for 'Reference' on my chart.

Is there a way to keep the line, but only plot within the Time for non-'Reference' products?

Re: Specify Dimension's range of values to ignore one of the lines

swuehl — Tue, 21 Feb 2012 19:41:27 GMT

Not really sure if I got you, maybe use

=aggr(only({<Product -= {Reference} >}Time) ,Time)

as calculated dimension instead of Time, to limit the Time values to values referenced by Products except Reference?

Re: Specify Dimension's range of values to ignore one of the lines

Thu, 02 Oct 2014 19:42:16 GMT

Much helped! Thanks!