Help with missing data in table

[#1]

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.

[Gysbert_Wassenaar]

See attached qvw

[#3]

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

[Gysbert_Wassenaar]

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.

[#5]

Thank you!

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

Greetings

[#6]

Hello Jeremias,

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

[Colin-Albert]

This blog should help

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

[#8]

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.

[#9]

Thank you for the information.

I didn't solve this problem yet.

Greetings.