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

    Can filters be applied to variables

    Hasvine Dhurmea

      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:

       

      Count({<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}{<CampaignId={'=E4D46547D63403B4'}>}{<FirstQueue={'0'}>}Indice)

       

      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?

       

      Thanks,

       

      Hasvine