Multiple Variables

[tigerfan81]

Below is a sample table in which I need to sum the pay by name and location.

I'm relatively new and need a little help with an if statement that involves checking 2 variables. I need to sum the pay if the name and location match.

This is a great forum. Thanks for all the help.....

[jvitantonio]

Check this out.

Or you can create directly a pivot table with sum(Pay) as an expression and Qlik will automatically group the values.

[#3 · Accepted solution]

Hi,

load your data in QlikView and create a pivot table and you get what you want.

See the attached example.

Good Luck!

Rainer

[#4]

Hi,

Try this..

Regards

.....