How can I show zero values from the script

[kavita25]

Is it possible to show zero values if the data is not presented in the back end??

For e.g

Jan 2015  300

Apr 2015  200

May 2015 100

So I want to show zero values for remaining months where data is not presented.

And for Last three months i.e Aug 2015,Jul 2015 and Jun 2015, the colour should be red.

i want to show this in line chart.

Please help me!!!

Its urgent!!!

Regards,

Kavita

[kavita25]

look at my qvw.

help me on this

[sasiparupudi1]

Please can you share a sample application?

[kavita25]

I have already shared

[kavita25]

gwassenaar‌MRKachhiaIMP‌jagan‌tresesco‌

Please help me with the above issue,...

[sunny_talwar]

Unfortunately, I am working with a personal edition of QlikView and won't be able to open your qvw. But with continuing with my example, I used this expression earlier:

=If(Len(Trim(Value)) = 0, Red(), Black())

Use this instead of you want the opposite:

=If(Len(Trim(Value)) = 0, Black(), Red())

[tresesco]

Take a little time out and have a look at this post: How to populate a sparsely populated field

[sasiparupudi1]

Try adding the expression to the background color on your expression

=if(Date(Today(1),'MMM YYYY')-Date#(CMonthYear,'MMM YYYY')<=90,Red(), Black())

hth

Sasi

[kavita25]

If( IsNull( Rate ), Peek( Rate ), Rate ) as Rate

This statement will take the previous values if values is not there...

instead i want zero values how can I do that???

[kavita25]

Unsuccessful

Can u look at my qvw & help me out

[tresesco]

If( IsNull( Rate ), 0, Rate ) as Rate

??