Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Dimension

I have a pivot table as given below where the dimension field is Description

Description     Actual     Budget

Sales             10000     15000

less Purchase   6000     10000

Gross Profit       4000     5000

Staff Expense    2000     3000

Other  Expense  1000     1000

Total Expenses   3000     4000

Profit                  1000     1000

Expression for Actual   is   sun(actual)    Budget is sum(Budget)

Now I want to calculate the rows highlighted in Red

Gross Profit= Sales-Purchase

Total Expense = Staff Expense+Other Expense)

Profit=  Gross profit-Total Expense

Pls  help me to calculate above rows in my pivot table

10 Replies
PrashantSangle

Hi,

is this same thread

p &L

As per my knowledge this is not possible.

You can not use Expression in between Dimension Values .

So try with some new logic to do the required output

Regards.

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

How is your datamodel?

upaliwije
Creator II
Creator II
Author

Thanks max

What logic would you suggest?

upaliwije
Creator II
Creator II
Author

My data model is based from an  excel sheet as follows

Description           Actual    Budget

Sales

Purchases

Sales

Staff Expenses

Other Expense

Puchase

So load the excel sheet and create the pivot table

MK_QSL
MVP
MVP

Can you provide sample data file in excel... I would love to work on this...

upaliwije
Creator II
Creator II
Author

Hi Swvehl

I have read it. Is there any simple way to do it ?

upaliwije
Creator II
Creator II
Author

Hi Manish

I attaching it

MK_QSL
MVP
MVP

Check enclosed file....