Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

arjanijlenhave
New Contributor II

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