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
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
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-11-10 05:21 AM

2 facts with different jobdate --> Set analysis?

Hi all,

I have the following issue

Fact1 is the head fact table with a linked DimDate dimension see below.

I want to create a straight table object that compares Amount_fact1, Amount_fact2 and Amount_fact3 bases on de date selection in the DimDate dimension. Can I solve this with Set Analysis in all the expressions?

Selections: (18-5-2015 - 24-5-2015)

Year = 2015

Month = sep

Week = 21

Product = VPB

Example:

Best regards,

Arjan

Labels (1)
Labels
443 Views
0 Likes
0 Replies