topic Re: Help with missing data in table in QlikView

Help with missing data in table

Thu, 29 Jan 2015 20:10:56 GMT

Hi everybody:

I'll put an example about this in my sample app.

I have "Money" when the client payed. When no, i don't have data.

If i have money i have green leds.

I put the option "complete rows without value" or something like that. Because of that i have the grey leds. But i wanna have red leds instead of the grey leds.

I have to create all the values that i don't have in my table "Money"

How i do this? What should i do ?

Thank you

Greetings.

Re: Help with missing data in table

Gysbert_Wassenaar — Fri, 30 Jan 2015 10:20:02 GMT

See attached qvw

Re: Help with missing data in table

Fri, 30 Jan 2015 12:41:42 GMT

Ok that's very interesting and useful!

But the problem is that because i don't have the missing values in the table if i select for example EveGreen99 i see only the values that i have, and i dont see the red leds.

Thank you!

Greetings

Re: Help with missing data in table

Gysbert_Wassenaar — Fri, 30 Jan 2015 12:50:53 GMT

A chart cannot show data that does not exist. You can either generate the missing data or live with what you get when you enable the option Show All Values for the Year-Month dimension.

Re: Help with missing data in table

Fri, 30 Jan 2015 14:30:55 GMT

Thank you!

Could you tell me please what i have to do to generate the missing data? What functions should i use ?

Greetings

Re: Help with missing data in table

Fri, 30 Jan 2015 14:33:11 GMT

Hello Jeremias,

In the data modelling you could load the Null Values with 0 so that QlikView could load it to the memory.

Re: Help with missing data in table

Colin-Albert — Fri, 30 Jan 2015 14:34:04 GMT

This blog should help

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/05/populating-a-sparsely-populated-field

Re: Help with missing data in table

Wed, 04 Feb 2015 15:00:40 GMT

Yeah, that'd be useful, but how i do this?

They aren't nulls, they're missing values or something like that

Thank you

Greetings.

Re: Help with missing data in table

Wed, 04 Feb 2015 15:01:18 GMT

Thank you for the information.

I didn't solve this problem yet.

Greetings.