Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

conditional expression help

Hi Experts,

I have attached a sample qvw.

It has branch wise sales and working days.

The first pivot table is showing correct days for a branch.

but the second pivot table is giving wrong working days as it is having customer numbers.

Please help me with the expression to show same working days in both the pivot tables.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try

=sum(TOTAL<Branch> WorkingDays)

in your second pivot table

View solution in original post

2 Replies
swuehl
MVP
MVP

Try

=sum(TOTAL<Branch> WorkingDays)

in your second pivot table

Not applicable
Author

thank u swuehl.