Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.....
Hi,
load your data in QlikView and create a pivot table and you get what you want.
See the attached example.
Good Luck!
Rainer
Check this out.
Or you can create directly a pivot table with sum(Pay) as an expression and Qlik will automatically group the values.
Hi,
load your data in QlikView and create a pivot table and you get what you want.
See the attached example.
Good Luck!
Rainer
Hi,
Try this..
Regards
.....