topic Show full range when making selection in QlikView

Show full range when making selection

Tue, 29 Apr 2014 11:03:06 GMT

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:

and not this:

Thanks!

Re: Show full range when making selection

maxgro — Tue, 29 Apr 2014 11:06:27 GMT

try this

check show all values in tab dimension

uncheck suppress zero values in tab presentation

Re: Show full range when making selection

jonathandienst — Tue, 29 Apr 2014 11:14:08 GMT

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

Re: Show full range when making selection

MK_QSL — Tue, 29 Apr 2014 11:14:14 GMT

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

Re: Show full range when making selection

sudeepkm — Tue, 29 Apr 2014 11:16:50 GMT

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?

Re: Show full range when making selection

Tue, 29 Apr 2014 11:28:44 GMT

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.