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

# 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:

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

• ###### Re: Can filters be applied to variables

Try this, if you have not already:

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

• ###### Re: Can filters be applied to variables

shouldnt it be ??

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

• ###### Re: Can filters be applied to variables

and may be use it with double quotes also?

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

• ###### Re: Can filters be applied to variables

I added the comma and its working fine.

Thanks,

Hasvine