topic How to calculate numeric values which particular column values have. in QlikView

How to calculate numeric values which particular column values have.

Tue, 21 Jun 2011 03:51:05 GMT

Hi all,

I started the Qlikview recently.

I'm Japanese.So I'm not speak English well.

If you don't understand what I said, please tell me about it.

I want to　calculate the gross profit. So I have to subtract cost amount from sale amount.

But the two amounts are in the same column, Account headline.

Would you mind checking the attachment file ?

I can't investigate how to calculate the two amounts.

Please tell me about it.

Thank you in advance.

Best regards,

Yusuke

Re: How to calculate numeric values which particular column values have.

Tue, 21 Jun 2011 05:23:33 GMT

Hi, Check out the attached application.

Hope this may help you.

- Sridhar

How to calculate numeric values which particular column values have.

Tue, 21 Jun 2011 06:26:55 GMT

Hi Sridhar,

How do I check the qvw file?

I got the message that said "it is not possible to open QlikView documents created by other users."

Regards,

Yusuke

Re: How to calculate numeric values which particular column values have.

kaushiknsolanki — Tue, 21 Jun 2011 06:45:07 GMT

Hi,

Create a pivot chart. Add followinf Dimentions

Year, Team, Amount Headline.

Add following expression.

1. give lable as "Sales" and Expression as Sum ({<[Account headline] = {'sale'}>} Amount).

2. give lable as "Cost" and Expression as Sum ({<[Account headline] = {'cost'}>} Amount).

3. give lable as "Gross Profit" and Expression as Column(1) - column(2).

Click ok and a povit chart will be available to you.

Drag the Amount Headline dimension at the top of the expression and you will get what you want.

Regards,

Kaushik Solanki

Re: How to calculate numeric values which particular column values have.

Tue, 21 Jun 2011 06:57:26 GMT

Yusuke,

Are you using Qlikview Personnel Edtion? i.e. are you using Qlikview without license?

If so.. you would not be able to open any Qlikview application which is developed by Personal Edition / Licensed edtion.

You should have two dimesions and three expressions.

Dimesion1 --> Year

Dimesion2 --> Team

Expression1 --> Sum ({<[Account headline] = {'sale'}>} Amount) // Expression For Sales

Expression2 --> Sum ({<[Account headline] = {'cost'}>} Amount) // Expression For Cost

Expression3 --> Column(1)-Column(2) // Expression For Gross Profit.

Check out the attached image. Qlikview pivot table look like the attached image.

- Sridhar

Re: How to calculate numeric values which particular column values have.

Tue, 21 Jun 2011 07:10:12 GMT

Hi Sridhar and Kaushik,

Thank you very much !

I could do what I wanted to do.

Regards,

Yusuke