Can filters be applied to variables

[#1]

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

[sunny_talwar]

Try this, if you have not already:

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

[sasiparupudi1]

shouldnt it be ??

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

[sunny_talwar]

and may be use it with double quotes also?

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

[#5]

I added the comma and its working fine.

Thanks,

Hasvine