Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-09-10 07:37 AM

Set Analysis - Three Months

Hi, I would like to apply set analysis to the attached table, comparing three months, per location. Thanks

Preview file
49 KB
1,717 Views
0 Likes
13 Replies
Not applicable
‎2015-09-10 09:12 AM
Author

Sorry you checked the attachment that you have sent?
Should solve the problem for your case.

testCommunity.qvw
389 Views
0 Likes
MK_QSL
MVP
MVP
‎2015-09-10 09:50 AM

In response to Anonymous

Create a Pivot Table

Dimension

Branch

Month

Expression

SUM([Received Amt])

389 Views
0 Likes
Anonymous
Not applicable
‎2015-09-13 03:10 AM
Author

In response to

The table you have created does not change when selecting Location ( Branch) from the drop List !!

example: If I selected "Aug"  table should show Aug and Jul and its variation.

389 Views
0 Likes
Anonymous
Not applicable
‎2015-10-07 04:35 AM
Author

Not solved yet !!

389 Views
0 Likes