topic Re: Graph help in QlikView

Graph help

Mon, 24 Mar 2014 16:42:39 GMT

HI, i need help to create a graph.

This is the problem:

Supouse you have the following table with data:

sell_id SellWeek AnulationWeek Amount

1 1 1 100

2 1 2 200

I want to create a graph with the x-axis with week and the y-axis amount. In the week 1 the amount must be 200, beacuse i sold 300 but i have a anulation of 100, in the second the amount must be -200, because i sold 0 and have 200 of anulation.

Can anyone help me?

Thanks,

Re: Graph help

MK_QSL — Mon, 24 Mar 2014 16:48:42 GMT

Can you elaborate AnulationWeek ?

Dont understood your requirements fully...:-(

Re: Graph help

Mon, 24 Mar 2014 16:57:56 GMT

AnulationWeek, is the week when a sell is canceled. Imagine that each row represents a reservation for a flight. And you can cancel that reservation, that is what AnulationWeek means..

Re: Graph help

MK_QSL — Mon, 24 Mar 2014 17:00:09 GMT

Got it, Can you provide 4-5 more sample lines to work?

Re: Graph help

Mon, 24 Mar 2014 17:12:59 GMT

In the image below its and example in excel.

If Anulationweek=1000 then de anulation week is null, the reservation is available.

Re: Graph help

maxgro — Mon, 24 Mar 2014 17:20:45 GMT

I added some records

this is the RESULT,see attachment or below for SCRIPT

Source:

load * inline [

sell_id, SellWeek, AnulationWeek, Amount

1 , 1 , 1 , 100

2 , 1 , 2 , 200

3 , 4 , 3 , 100

4 , 5 , 4 , 200

];

load

SellWeek as Week,

1 as Type,

sell_id

resident Source;

load

AnulationWeek as Week,

-1 as Type,

sell_id

resident Source;

Re: Graph help

Mon, 24 Mar 2014 18:19:28 GMT

Thank you!

It works fine