topic Multiple Variables in QlikView

Multiple Variables

tigerfan81 — Mon, 27 Feb 2012 13:30:12 GMT

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.....

Re: Multiple Variables

jvitantonio — Mon, 27 Feb 2012 13:36:16 GMT

Check this out.

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

Re: Multiple Variables

Mon, 27 Feb 2012 13:39:56 GMT

Hi,

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

See the attached example.

Good Luck!

Rainer

Re: Multiple Variables

Mon, 27 Feb 2012 13:56:51 GMT

Hi,

Try this..

Regards

.....