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: 
fzalexanderjohn
Creator
Creator

Ignore selection with a dimension (without using a measure)?

Hello,

Say I have these two tables:

AddressNumberCatagoryCustomer
20000110A
20000210B
20000310A
20000420C
20000520D
20000610E
20000740F
20000850G
20000910H

 

And

YearSalesCustomer
2013500A
2014501B
2015502A
2016234243C
2017234244D
2018234245E
2019234246F
2020234247G
2021123123H

 

They are associated via Customer.

What I want is a straight table that shows all customers even if I select a year in the field year.

So NOT like this:

grafik.png

Labels (3)
2 Replies
jfkinspari
Partner - Specialist
Partner - Specialist

Include a measure in the table with Set expression e.g.

Count( {$<Year= >} Customer)

fzalexanderjohn
Creator
Creator
Author

So right now it is not possible to do this without using a measure?