topic Re: No zero on line chart in QlikView

No zero on line chart

rajeshvaswani77 — Mon, 03 Nov 2014 12:32:39 GMT

Hi Community,

I have a simple example like

Table name

T1:

Load * inline

[

Date, Country, Qty

1/1/2014, IND, 10

1/1/2014, THI, 10

1/2/2014, IND, 10

1/2/2014, THI, 10

1/3/2014, THI, 0.00

1/4/2014, IND, 5

1/4/2014, THI, 5

];

Note that here in the table, for 1/3/2014 THI is 0 and IND has no record. The Requirement is that for this data as it is, in the line chart it must show 0 for IND also for 1/3/2014 by changing an expression. Right now there will be nothing plotted for 1/3/2014 IND since the data is not there. However the pivot shows correctly for both? Is there a way to achieve this. Please find the attached QVW.

thanks,

Rajesh Vaswani

Re: No zero on line chart

MK_QSL — Mon, 03 Nov 2014 12:45:12 GMT

Change you script as below

As your data for IND and THI are same, I have changed Qty for IND

=========================

T1:

Load * inline

[

Date, Country, Qty

1/1/2014, IND, 20

1/1/2014, THI, 10

1/2/2014, IND, 20

1/2/2014, THI, 10

1/3/2014, THI, 0

1/4/2014, IND, 10

1/4/2014, THI, 5

];

MinMaxDate:

Load Min(Date) as MinDate, Max(Date) as MaxDate Resident T1;

Let vMin = NUM(PEEK('MinDate',0,'MinMaxDate'));

Let vMax = NUM(PEEK('MaxDate',0,'MinMaxDate'));

Drop Table MinMaxDate;

Calendar:

Load

Date($(vMin) + IterNo() - 1) as Date

AutoGenerate 1

While $(vMin) + IterNo() - 1 <= $(vMax);

Join

Load Distinct Country Resident T1;

Left Join (Calendar)

Load * Resident T1;

Drop Table T1;

Re: No zero on line chart

rajeshvaswani77 — Mon, 03 Nov 2014 12:49:05 GMT

Thanks for replying Manish, we want to do only expression change. The script change would be quite expensive for the current stage of release we are in.

If we can do this with just expression change please suggest.

thanks,

Rajesh Vaswani

Re: No zero on line chart

MK_QSL — Mon, 03 Nov 2014 12:56:15 GMT

As far as I know, 3rd Jan is not associated with IND, it's difficult to show 0 for the same without changing the script...

May be someone can come with better idea... I don't have any other solution... Sorry...

Would love to read comments from other members on this...

Re: No zero on line chart

JonnyPoole — Mon, 03 Nov 2014 19:28:36 GMT

How many countries will you have ?

If its low and static, consider removing dimension as a country and adding multiple expressions

Re: No zero on line chart

trey_bayne — Mon, 03 Nov 2014 19:56:10 GMT

Take Country out of the dimension.

Create two Expressions.

sum( {$ < Country = {'THI'} > } Qty)

and

sum( {$ < Country = {'IND'} > } Qty)

Be aware that the lines overlap then though so you won't see both.

Re: No zero on line chart

its_anandrjs — Mon, 03 Nov 2014 20:14:10 GMT

Hi,

If you take the dimension Date and Country this works well also where is problem let me know

Regards

Anand