topic Re: Formula error in QlikView

Formula error

Thu, 13 Aug 2015 09:58:38 GMT

Hello All,

I am trying to calculate all the calls of all my campaigns in an sql table for the day except for this campaign E4D46547D63403B4.

This is my actual formula but unfortunately it is not working:

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

Any idea?

Thanks,

Hasvine

Re: Formula error

sunny_talwar — Thu, 13 Aug 2015 09:59:56 GMT

Try this:

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

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

Re: Formula error

MK_QSL — Thu, 13 Aug 2015 10:00:12 GMT

=Count({<

CampaignId-={'E4D46547D63403B4'}

Indice)

If you want records for date greater than equal to max date and less than equal to max date, means all date.. No need of Date filter/selection.

Re: Formula error

maxgro — Thu, 13 Aug 2015 10:06:08 GMT

all campaigns of the selection except E4....

=Count({<CampaignId-={'E4D46547D63403B4'} Indice)

all campaigns except E4....

=Count({<CampaignId=-{'E4D46547D63403B4'} Indice)

Re: Formula error

sasiparupudi1 — Thu, 13 Aug 2015 10:12:17 GMT

Count({<Date={"$(=Max(Date))"}, CampaignId-={'E4D46547D63403B4'}Indice)

Re: Formula error

sunny_talwar — Thu, 13 Aug 2015 10:12:17 GMT

Just a minor change here: I overlooked it also the first time

all campaigns of the selection except E4....

=Count({<CampaignId-={'E4D46547D63403B4'}>} Indice)

all campaigns except E4....

=Count({<CampaignId=-{'E4D46547D63403B4'}>} Indice)

Re: Formula error

Thu, 13 Aug 2015 10:17:18 GMT

Hi Manish,

The calculation works but i need the calculation for today's date only but it is giving me for all the data in the table.

KR,

Hasvine

Re: Formula error

maxgro — Thu, 13 Aug 2015 10:18:12 GMT

thanks

Re: Formula error

sunny_talwar — Thu, 13 Aug 2015 10:19:05 GMT

Try this:

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