topic Re: Graph with calculated dimension does not show data in QlikView

Graph with calculated dimension does not show data

Mon, 01 Aug 2016 09:34:24 GMT

Dear all,

I would like to create a graph that shows the amount of order per customer_id and also show the sum of the orders.

For this I have the following dataset:

LOAD * INLINE [
Employee_ID, Customer_id, Order_id, Order_total
1, 11, 6, 12
2, 12, 7, 14
3, 13, 8, 176
4, 14, 9, 12
5, 15, 10, 8
];

With this data I try to create a bar-chart with the following details:

- An calculated dimension: =Aggr(Count([Order_id]), [Customer_id])

- An expresiion: =Aggr(Sum([Order_total]), [Employee_ID])

When I look at the graph however no data shows up. Any thoughts on what I am doing wrong here?

Re: Graph with calculated dimension does not show data

kaushiknsolanki — Mon, 01 Aug 2016 09:38:29 GMT

HI,

You can try just Sum([Order_total]) as an expression.

If that doesnt work then tell us What output you are expecting from the sample data.

Regards,

Kaushik Solanki

Re: Graph with calculated dimension does not show data

Mon, 01 Aug 2016 09:39:05 GMT

you should create bar chart having customer id as dimension and two expression as below:

Expr1: Count([Order_id])

Expr2: Sum([Order_total])

Re: Graph with calculated dimension does not show data

Anonymous — Mon, 01 Aug 2016 09:45:14 GMT

Not sure why you are using calculated dimension. It's always better to avoid these where possible as they have a negative effect on performance. Can you share you're expected output?

Re: Graph with calculated dimension does not show data

Anonymous — Mon, 01 Aug 2016 09:51:51 GMT

add Customer id as dimension and expression as Order amount

Re: Graph with calculated dimension does not show data

sunny_talwar — Mon, 01 Aug 2016 10:40:43 GMT

I think I agree with meghaagr‌, is there a reason you are not doing this?

Re: Graph with calculated dimension does not show data

Tue, 02 Aug 2016 07:48:28 GMT

It was just for training purposes as I wanted to get a better understanding of the calculated dimension topic...