Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
flagamba
Contributor III
Contributor III

How to ignore all dimensions related to calendar in set expression

Hello Community,
I need help with the following problem:
I have a MasterCalendar with (as usual) many fields (15+).
I also have a table "Facts" obtained by concatenation of two tables T1 and T2.

I can make selections on fields that are in common with the two tables.
I can also select a time period or any dimension related to the calendar.

But this selection must act only on the T2 part and not on the T1 part
where the date is not defined (null).

I saw that I can get the correct result using the set analysis
"eliminating" all dimensions related to the calendar.

However it is a very boring thing...

I therefore ask if there is a method to achieve the result without having
to mention all the fields to be ignored.

Any help is welcome ...

Labels (5)
1 Reply
BrunPierre
Partner - Master
Partner - Master

I take it that you want to include some but not all dimensions, especially the time dimensions.

The below expression disregards all dimension values with the exception of customer and Sales representative.

For example, Sum(Total <Customer, [Sales representative]>Sales)

I hope it helps.