topic Re: Show all dimensions without expression in QlikView

Show all dimensions without expression

Fri, 18 Jul 2014 08:07:07 GMT

Is it possible to show all the dimensions at all time, even if there is no expression for it.

It works when I use an extra expression (=1) but I don't want to show a a column with 1 in it.

Kind regards,

Katleen

tresB — Fri, 18 Jul 2014 08:08:53 GMT

Uncheck 'Supress Zero-Values' in presenation tab. Then it works without expression.

alexandros17 — Fri, 18 Jul 2014 08:08:56 GMT

2 ways:

a) In a Chart used as straight table (not pivot) you can hide the column with expression 1

b) If you do not need expression you may use a table (not a chart)

Let me know

Fri, 18 Jul 2014 08:11:51 GMT

It doesn't seem to work in a pivot table

tresB — Fri, 18 Jul 2014 08:20:01 GMT

It works with me. PFA

Fri, 18 Jul 2014 08:46:30 GMT

Made a new table and it works!

thank you