topic Re: How can I show zero values from the script in QlikView

How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 10:40:17 GMT

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

Re: How can I show zero values from the script

sunny_talwar — Tue, 08 Sep 2015 10:42:20 GMT

Do you have a master calendar with the remaining months in the application?

Re: How can I show zero values from the script

avinashelite — Tue, 08 Sep 2015 10:44:04 GMT

use the combination of master calendar and join ...to populate the missing

Re: How can I show zero values from the script

gautik92 — Tue, 08 Sep 2015 10:44:08 GMT

mastercalendar can do that

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 10:46:14 GMT

Yess... to generate the rest of the months I have used Master Calendar

Re: How can I show zero values from the script

sunny_talwar — Tue, 08 Sep 2015 10:48:45 GMT

Have you tried unchecking 'Suppress Zero Values' on the Presentation tab??? May be that will helps

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 10:50:22 GMT

I have tried everything in front end...

I am able to achieve zero values for the rest of the month from front end..

But Last three months values is not identified by red colour.

Re: How can I show zero values from the script

sunny_talwar — Tue, 08 Sep 2015 10:58:29 GMT

Here is an example:

Script:

Table:

LOAD MonthName(Date) as MonthYear,

Value;

LOAD * Inline [

Date, Value

01/01/2015, 300

02/01/2015, 200

03/01/2015, 100

];

MasterCalendar:

LOAD MonthName(Date) as MonthYear;

LOAD * Inline [

Date

01/01/2015

02/01/2015

03/01/2015

04/01/2015

05/01/2015

06/01/2015

];

Straight Table

Dimension: MonthYear

Expression: =If(Len(Trim(Value)) = 0, 0, Value)

Output:

Suppress Zero-Values is unchecked:

HTH

Best,

Sunny

Re: How can I show zero values from the script

sunny_talwar — Tue, 08 Sep 2015 11:01:20 GMT

Here is the screenshot for a line chart with Black for monthsyears with data and red for monthyears with no data:

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 11:25:03 GMT

I want the red colour for last three months, not for zero values.

In ur attached example u have coloured to those values where its zero...

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 11:29:49 GMT

look at my qvw.

help me on this

Re: How can I show zero values from the script

sasiparupudi1 — Tue, 08 Sep 2015 11:31:11 GMT

Please can you share a sample application?

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 11:46:13 GMT

I have already shared

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 11:49:20 GMT

gwassenaar‌MRKachhiaIMP‌jagan‌tresesco‌

Please help me with the above issue,...

Re: How can I show zero values from the script

sunny_talwar — Tue, 08 Sep 2015 11:51:04 GMT

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())

Re: How can I show zero values from the script

tresB — Tue, 08 Sep 2015 12:02:57 GMT

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

Re: How can I show zero values from the script

sasiparupudi1 — Tue, 08 Sep 2015 12:10:41 GMT

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

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 12:13:11 GMT

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???

Re: How can I show zero values from the script

kavita25 — Tue, 08 Sep 2015 12:15:41 GMT

Unsuccessful

Can u look at my qvw & help me out

Re: How can I show zero values from the script

tresB — Tue, 08 Sep 2015 12:18:36 GMT

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