4 Replies Latest reply: Jul 29, 2015 7:48 AM by Hasvine Dhurmea RSS

    Can filters be applied to variables

      Hello All,


      I have build a table on qlikview where I applied the date filter and the company name filter.


      See attached screenshot:



      However, I need to create variables in order to use them while designing the Nprinting mail subject which needs to be send on a daily basis.


      My formula for the Appels Totals is : Count({<FirstQueue={'<>0'}>}Indice) and as shown it is working fine.


      However, when I apply the formula below on my variable calculation, it gives me a totally different result:




      Is it possible to use the formula Count({<FirstQueue={'<>0'}>}Indice) and apply the Filter Date and name to it?


      Or is there an easier way?