Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor III

link filters

Dear Community,

I have two tables (Excel) that I have loaded in Qlik Sense. I'm trying to find a way to link 2 filters.For example I have two dimensions "Type1" (first table) and "Type2" (sencond table) and the values can be A, B, C, etc...

I want that when the user select in "Type1", "A", that automaticaly in "Type2" the filter is set to "A". But I can not make "Type" as a key between the 2 tables because i already have one. And I want to do the same for each column in my 2 files, so that makes a lot of keys!

Basicaly in my chart I want: Count(if([Type2]='A',[ID]))  only that "A" can change depending on what is selected in "Type1". And this doesn't work: Count(if([Type2]=[Type1],[ID])) because it is then counting everything all the time no matter the filter I set in "Type1".

I hope it's more or less clear.

Best regards


Community Browser