Plotting facts along x-axis

Tue, 21 Apr 2009 03:24:29 GMT

I am just wondering if there is anyway by which we can have facts on x-axis and dimensions along Y-axis.

I have the following situation.

QVFACTS1:
LOAD
key,
branch, // dimension
target_sales, // is a fact
actual_sales // is a fact
resident table // concatanating many resident tables

Now , users wanted to have target_sales,actual_sales (i.e. facts) on x -axis and branch (i.e. dimension) on y-axis,which I think is not possible in QlikView.

So I had to create another table off of previously created table,just to be able to have these kind of charts.

QVFACTS2:
LOAD
key,
target_sales As fact,
'target_sales' as facttype
resident QVFACTS1;
concatenate
LOAD
key,
actual_sales As fact,
'actual_sales' as facttype
resident QVFACTS1;

Now, I plot a chart using facttype,branch as dimensions and sum(fact) as an expression, which serves the purpose.

But my problem is I am going to have millions of records and creating another tabel just for the sake of having these charts is not making any sense to me.

Please help me if there is any other workaround.

Thanks.

Plotting facts along x-axis

Tue, 21 Apr 2009 03:45:06 GMT

You should be able to use the Orientation options under the Style tab on a bar or line chart to choose which axis to place the dimensions.

The second option should put the dimensions on the y-axis.

topic Plotting facts along x-axis in QlikView

Plotting facts along x-axis

Plotting facts along x-axis