Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Formula error

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

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

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

View solution in original post

8 Replies
sunny_talwar

Try this:

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


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

MK_QSL
MVP
MVP

=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.

maxgro
MVP
MVP


all campaigns of the selection except E4....

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



all campaigns except E4....

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

sasiparupudi1
Master III
Master III

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

sunny_talwar

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)

Not applicable
Author

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

maxgro
MVP
MVP

thanks

sunny_talwar

Try this:

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