Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

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?

1 Solution

Accepted Solutions
MVP
MVP

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

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)

4 Replies
MVP
MVP

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

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)

Not applicable

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

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?

MVP
MVP

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

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?

Not applicable

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

Much helped! Thanks!

Community Browser