Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II
‎2014-10-09 02:24 AM

Pivot Table

Hi Friends

I have following data in a Pivot Table

DESCRIPTIONACTUALBUDGETDISCOUNTED
GROSS_PROFIT183,737,772232,613,759202,521,006
TOTAL_EXPENSES249,717,518255,268,534249,717,518
OTHER_INVEST_INCOME39,947,66657,896,82550,406,834
NET_PROFIT(26,032,081)35,242,04930,682,859

Expected Value(Gross_Profit-Total_Expenses+Other_Income) 3,210,332

I want to calculate the Value of Rs.3,210,332 instead of 30,682,859(highlighted in red)

Pls help me

367 Views
0 Likes
3 Replies
upaliwije
Creator II
Creator II
‎2014-10-09 05:18 AM
Author

Can someone pls help me to solve my issue

310 Views
0 Likes
anbu1984
Master III
Master III
‎2014-10-09 05:22 AM

In response to upaliwije

Can you attach sample qvw

310 Views
0 Likes
its_anandrjs
Champion III
Champion III
‎2014-10-09 05:49 AM

In response to upaliwije

Explain more or please provide sort sample file for this.

310 Views
0 Likes