Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
fzalexanderjohn
Contributor III
Contributor III

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
Partner

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

Count( {$<Year= >} Customer)

fzalexanderjohn
Contributor III
Contributor III
Author

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