Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
What's the better way to calculate the output table based on input table below?
Category, state are dimensions. Amount fields are expressions in a straight table in QlikView.
Input:
Category | State | Amount1 | Amount2 |
A1 | CA | - | 1,000 |
A1 | NY | - | 1,500 |
B2 | CA | 5,000 | - |
B2 | NY | 4,500 | - |
Output:
Category | State | Amount |
B2 | CA | 4,000 |
B2 | NY | 3,000 |
@newqlik2017 can you elaborate ?