Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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?