Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi, Check out the attached application.
Hope this may help you.
- Sridhar
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
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
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
Hi Sridhar and Kaushik,
Thank you very much !
I could do what I wanted to do.
Regards,
Yusuke