Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

How to calculate numeric values which particular column values have.

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

1 Solution

Accepted Solutions
Not applicable

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

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

5 Replies
Not applicable

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

Hi, Check out the attached application.

Hope this may help you.

- Sridhar

Not applicable

How to calculate numeric values which particular column values have.

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.

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

Not applicable

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

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

Not applicable

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

Hi Sridhar and Kaushik,

Thank you very much !

I could do what I wanted to do.

Regards,

Yusuke

Community Browser