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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Varience

I have calculated Variance (Actual_Budget) in my pivot table which is attache H/w

I want to the Variance to appear as follows

GROUP_DESCRIPTION

Actual

Budget

varience

SALES

100,000

150,000

(50,000)

COST OF SALES

40,000

70,000

(30,000)

GROSS_PROFIT

60,000

80,000

(20,000)

STAFF_EXPENSES

10,000

15,000

5,000

ADMIN_EXPENSES

2,000

3,000

1,000

SELLI_EXPENSES

4,000

6,000

2,000

FINAN_EXPENSES

1,000

1,500

500

TOTAL_EXPENSES

7,000

10,500

3,500

OTHER INCOME

3,000

4,500

(1,500)

NET_PROFIT

50,000

65,000

(15,000)

Favorable Variance should be green without brackets. But in my Pivot table it is shown within brackets

Pls correct my expression to suit my requirement

Labels (1)
0 Replies