topic Re: Tricky question (With data and qlikview sheet attached) in QlikView

Tricky question (With data and qlikview sheet attached)

Sun, 29 Nov 2015 15:22:55 GMT

Hi there,

I would like to achieve something like in my attached output excel file.

Data is attached with qlikview named Summary.

To achieve the output percentage For the comparison by product section, say for example January 2014,

i would first need to perform a few steps:

(Raw data attached to qlikview is individual transactions)

1. Sum up all similar transactions by product code, year and month. ( this would mean there would be a sum of total charged and paid for each product, each year, each month. This can be seen already done in the qlikview straight table by plainly using sum(charged) and sum(paid)

Thank you so much for your time. I know this question must be rather long, it will really be great if any of you could help me on this.

Thank you again.

Re: Tricky question (With data and qlikview sheet attached)

Gysbert_Wassenaar — Mon, 30 Nov 2015 08:51:48 GMT

I don't understand why you use a different month range for the sum of Charged then for sum of Paid only for January 2014. For the other months you use the same period for Charged and Paid. If that's a mistake see attached example.

Re: Tricky question (With data and qlikview sheet attached)

Mon, 30 Nov 2015 09:01:38 GMT

Hi Gysbert, thats a mistake, suppose to be divided by the same period.

yes it is exactly as i need. Is there a way to shorten the load time? I have another similar dataset, with 1million entries.

Also
How do i autoplot a graph with the percentages then? a Dual line graph, one for product a one for product b?

Thanks dude. Lifesaver, going to try it out now.

Re: Tricky question (With data and qlikview sheet attached)

Gysbert_Wassenaar — Mon, 30 Nov 2015 09:53:29 GMT

Is there a way to shorten the load time?

Load less data or get faster hardware.

Re: Tricky question (With data and qlikview sheet attached)

Tue, 01 Dec 2015 01:40:05 GMT

I managed to load less data by changing iteration to <=24, i was thinking since i only need 12 months, what if i change 12<iteration<=24? Any idea how do i do this? not too sure with commands in load script area.

Thank you.