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.....
Check this out.
Or you can create directly a pivot table with sum(Pay) as an expression and Qlik will automatically group the values.
load your data in QlikView and create a pivot table and you get what you want.
See the attached example.
Retrieving data ...