topic Re: need help in the charts in QlikView

need help in the charts

alexpanjhc — Fri, 04 Apr 2014 21:13:41 GMT

I have a table that has all the historical data,

customer_no,period,balance($)

1,Jan,100,

1,Feb,201,

1 ,Mar,224,

1,Apr,500,

2,Jan,50,

2,Feb,110,

2 ,Mar,330,

2,Apr,500,

3,Jan,60,

3,Feb,100,

3,Mar,70,

3,Apr,80,

so i created a pivot table based on the histrical data.

customer_no/Period	Jan	Feb	Mar	Apr
1	100	201	224	500
2	50	110	330	220
3	60	100	70	80

Now, I want to know that if a customer had a jum of $100 from say Feb and Apr, and I want to know that customer number.

How do I create a table?

notice that I can't create a field in the load for the difference because we could be asking any 2 months that we have a jump of $100.

the result should look something like that.

customer/period	Feb	Apr
1	201	500
2	110	500

How do I achive that?

Re: need help in the charts

maxgro — Fri, 04 Apr 2014 21:51:18 GMT

Re: need help in the charts

nagaiank — Sat, 05 Apr 2014 00:47:43 GMT

A sample implementation for the data provided by you is attached. You may devise a solution like this for your actual application.

Re: need help in the charts

alexpanjhc — Mon, 07 Apr 2014 14:11:10 GMT

Hi NagaianK

Thanks for the reply, but I do not think I understand your solution.

Were you marking all the values greater than 100?

If I look at Feb and Mar, customer 1 should not show in the list.

i do not think thats what I wanted.

Thanks!

Re: need help in the charts

alexpanjhc — Mon, 07 Apr 2014 14:18:37 GMT

Massimo

Thanks, this is very helpful.
However, the dataset is huge(4gig) for the table and then to create another one to join maybe very costly. I am not sure how to get that part done.

Thank you!