Null values in dimension

Thu, 13 Oct 2016 10:21:53 GMT

Hi everyone,

Here is a sample of my data:

Date_bla customers

12/10/2016 5

11/10/2016 2

10/10/2016 3

09/10/2016 1

I want a table that dispays only the last 2 days like this:

Date_bla customers

12/10/2016 5

11/10/2016 2

So I create a calculted dimension : =if([Date_bla] >= Floor(ReloadTime())-2, [Date_bla] )

The table I get is:

Date_bla customers

12/10/2016 5

11/10/2016 2

- 4

I don't want te last line to be displayed ! I tried to add the condition on date in the expression as well (even if according to me, I shouldn't need it) : =if([Date_bla] >= Floor(ReloadTime())-2, sum(customers))

but then I still get a line with null values ...

Date_bla customers

12/10/2016 5

11/10/2016 2

- -

What's wrong ?

In the loaded data, all the "customers" have a Date_bla, so I don't get why null values appear...

Thanks for your help.

Have a good day

Laura

Re: Null values in dimension

sunny_talwar — Thu, 13 Oct 2016 10:24:27 GMT

I think you just need to select 'Suppress When Value Is Null' on the dimensions tab of your chart properties for your calculated dimension for the null value to go away.

Re: Null values in dimension

sunny_talwar — Thu, 13 Oct 2016 10:26:25 GMT

Or you can use set analysis to do this

Dimesnion

[Date_bla]

Expression

Count({<[Date_bla] = {"$(='>=' & Date(Floor(ReloadTime()-2), 'DD/MM/YYYY'))"}>} Customer)

topic Null values in dimension in QlikView

Null values in dimension

Re: Null values in dimension

Re: Null values in dimension