Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
fzalexanderjohn
New 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
Partner
Partner

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

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

Count( {$<Year= >} Customer)

fzalexanderjohn
New Contributor III

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

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