Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Show full range when making selection

Hi,

I want to let my graph/table always show the full range of a dimension, even if I make a selection.

For example, if I have in my graph "month" as dimension, and I select only March with a list box, how can I have Qlikview just show a 0-value for all other months and the data for March, in stead of removing all the other months from my graph?

So I want something like this:

Monthchart1.bmp

and not this:

Monthchart2.bmp

Thanks!

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Show full range when making selection

try this

check show all values in tab dimension

uncheck suppress zero values in tab presentation

View solution in original post

5 Replies
MVP
MVP

Re: Show full range when making selection

try this

check show all values in tab dimension

uncheck suppress zero values in tab presentation

View solution in original post

MVP
MVP

Re: Show full range when making selection

Hi

Assuming that your chart expression is

Sum(Shipments)

and your month dimension is Months, then use something like

=Sum({<Month= >} If(Index(Concat(Month, ','), Month), Shipments))

and uncheck Suppress Zero Values.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: Show full range when making selection

Do as Below

Dimension Tab

Untick Suppress When Value is NULL

Tick Show All Values

Expression Tab

Tick Value on Data Points

Presentation Tab

Untick Suppress Zero Value

Tick Zero On Bars

Hope this helps..

Highlighted
sudeepkm
Valued Contributor III

Re: Show full range when making selection

I'm not sure if there are any direct options available which can show the ones not selected on a graph.

I think using layout tricks this can be achieved. Can you please post your sample qvw?

Not applicable

Re: Show full range when making selection

Ok, so I fixed it for my graphs like this. Anybody knows how to arrange this for my pivot too? Because just checking show all values and unchecking suppress zero values didnt work here.