topic Re: Show hidden values in pivot table in QlikView

Show hidden values in pivot table

Thu, 30 Oct 2014 14:19:26 GMT

Hello everyone,

So I am having some trouble with null values in pivot and straight tables.

On the table box that follows I show 3 time values, but I want to use pivot or straight tables because I have to color cell based on a result.

My problem is that both the pivot table and the straight table join two time results and show a dash ( - ) or 'null' instead.

How can I show all the values with the pivot or straight table?

Straight table:

Pivot table:

Thanks in advance.

Best regards,

Ivo Marques

Thu, 30 Oct 2014 14:22:20 GMT

Hi,

What is the expression you are using.

Tablebox will show just the data from the fields selected

But in straight table or Pivot you need to specify an expression either count,sum,avg(some aggregation)

Thu, 30 Oct 2014 14:31:44 GMT

Hi,

The expression I am using is only a field:

HoraTeste

I am not using an expression with count, cum, avg, etc

Thu, 30 Oct 2014 14:38:47 GMT

Try Adding all dimensions to left including Hora Teste and hide expression under Presentation tab using Hide Column option

Thu, 30 Oct 2014 14:44:07 GMT

Well that is a nice little trick and it works for what I want!

Thank you!