topic How to fix the value of a filter on a table while using global filters in QlikView? in QlikView https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858636#M655623 <HTML><HEAD></HEAD><BODY><P>Hy, guys.</P><P></P><P>I need a big help.</P><P></P><P>I created three pivot tables in the same tab, one for the current month (June), another for the month - 1 (May) and the last M - 2 (April).</P><P></P><P>For each table, need a unique date filter in which, for tohe month Current Table, the filter is from 01/06 to today, for the month - 1 is from&nbsp; 01/05 to 31/05...</P><P></P><P>Ultil then everything ok.</P><P></P><P>The problem occurs when I need to apply global filtersto all these tables, that is, when I select the filter client, it should be applied in three tables and, when I aplly rhe filter of the month, it be applied only in the table related to it.</P><P></P><P>Has anyone done this before?</P><P></P><P>Thank you very much.</P><P></P><P>Meirieli.</P><P></P><P>Mensagem editada por: Meirieli Ribeiro</P></BODY></HTML> Tue, 09 Jun 2015 15:05:30 GMT 2015-06-09T15:05:30Z How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858636#M655623 <HTML><HEAD></HEAD><BODY><P>Hy, guys.</P><P></P><P>I need a big help.</P><P></P><P>I created three pivot tables in the same tab, one for the current month (June), another for the month - 1 (May) and the last M - 2 (April).</P><P></P><P>For each table, need a unique date filter in which, for tohe month Current Table, the filter is from 01/06 to today, for the month - 1 is from&nbsp; 01/05 to 31/05...</P><P></P><P>Ultil then everything ok.</P><P></P><P>The problem occurs when I need to apply global filtersto all these tables, that is, when I select the filter client, it should be applied in three tables and, when I aplly rhe filter of the month, it be applied only in the table related to it.</P><P></P><P>Has anyone done this before?</P><P></P><P>Thank you very much.</P><P></P><P>Meirieli.</P><P></P><P>Mensagem editada por: Meirieli Ribeiro</P></BODY></HTML> Tue, 09 Jun 2015 15:05:30 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858636#M655623 2015-06-09T15:05:30Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858637#M655624 <HTML><HEAD></HEAD><BODY><P>how are us filtering the data for each month ?</P><P></P><P>are you doing a set analysis for it or a calculated dimension?</P></BODY></HTML> Tue, 09 Jun 2015 18:18:45 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858637#M655624 ramoncova06 2015-06-09T18:18:45Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858638#M655625 <HTML><HEAD></HEAD><BODY><P>Hi Meirieli,</P><P></P><P>Have you tried implementing alternate states?</P><P></P><P>That could be what you are looking for?</P><P></P><P>Here is a link to give you an idea</P><P></P><P><A href="https://community.qlik.com/thread/114739">what is alternate states in Qlikview ?</A></P></BODY></HTML> Tue, 09 Jun 2015 18:51:59 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858638#M655625 sinanozdemir 2015-06-09T18:51:59Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858639#M655627 <HTML><HEAD></HEAD><BODY><P>Hi, Ramon.</P><P></P><P>yes, it is this. I applied one filter on the script to define how month I want.</P><P></P><P>I,m used calculated dimension. </P><P></P><P>Thanks.</P></BODY></HTML> Wed, 10 Jun 2015 15:05:33 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858639#M655627 2015-06-10T15:05:33Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858640#M655628 <HTML><HEAD></HEAD><BODY><P>sorry I didn't read the full requirement,</P><P></P><P>check the attached example, it uses alternate states </P></BODY></HTML> Wed, 10 Jun 2015 18:44:20 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858640#M655628 ramoncova06 2015-06-10T18:44:20Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858641#M655629 <HTML><HEAD></HEAD><BODY><P>Perfect, that was it I needed!</P><P></P><P>Thank You! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 10 Jun 2015 20:11:56 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858641#M655629 2015-06-10T20:11:56Z Re: How to fix the value of a filter on a table while using global filters in QlikView? https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858642#M655630 <HTML><HEAD></HEAD><BODY><P>Glad it worked, please mark the thread as closed </P><P></P><P>thanks </P></BODY></HTML> Wed, 10 Jun 2015 20:54:31 GMT https://community.qlik.com/t5/QlikView/How-to-fix-the-value-of-a-filter-on-a-table-while-using-global/m-p/858642#M655630 ramoncova06 2015-06-10T20:54:31Z