filter panel - with a filtering ecuation

[ernoszini]

Hi ! hello every body !!

I'm new here, so please forgive any mistakes in advance!

Im starting with some dashboards in qliksense, and I'm fighting with the next topic ... The table that I show, has as fields, a mail code, then there are 12 columns (1 for each month of the year), indicating a 1 if the person entered a web page in that month, 0 if he did not). How can I build a filtering panel that allows me to select the people "who have entered at least N months on that page"? (in principle, any N months, later I will think about how to get to M consecutive months!)

thank you very much !!!

[ernoszini]

Hi ! hello every body !!

I'm new here, so please forgive any mistakes in advance!

Im starting with some dashboards in qliksense, and I'm fighting with the next topic ... The table that I show, has as fields, a mail code, then there are 12 columns (1 for each month of the year), indicating a 1 if the person entered a web page in that month, 0 if he did not). How can I build a filtering panel that allows me to select the people "who have entered at least N months on that page"? (in principle, any N months, later I will think about how to get to M consecutive months!)

thank you very much !!!

[dwforest]

i load script add a column to total the 12, then filter would be any value over N.

[ernoszini]

Hi, thanks for the prompt response. This is how I have it until now, but that gives me back the users who entered exactly N months.

I can not get back "at least 5 months". Example. The column of the attached file, "cantidad", adds the number of months with a "1", and I used  that column for the filter panel.

If I select 5, I see that the user "walther.8090" entered exactly 5 different months. But if I select 4, that user no longer appears, and according to the query I want to make, it should appear ...

so, to see "walhter.8090" on the list, I have to select 4 AND 5 togheter ...