0 Replies Latest reply: Jul 21, 2015 9:23 AM by xavier hemelaar RSS

    link filters

    xavier hemelaar

      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

       

      Xavier