Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

tigerfan81
New Contributor

Multiple Variables

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.

Capture.JPG

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

1 Solution

Accepted Solutions
Not applicable

Re: Multiple Variables

Hi,

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

See the attached example.

Good Luck!

Rainer

3 Replies
jvitantonio
Valued Contributor III

Re: Multiple Variables

Check this out.

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

Not applicable

Re: Multiple Variables

Hi,

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

See the attached example.

Good Luck!

Rainer

Not applicable

Re: Multiple Variables

Hi,

Try this..

Regards

.....

Community Browser