topic Re: Error in expression in QlikView

Error in expression

Fri, 21 Aug 2015 10:37:31 GMT

Hello All,

I have an issue with a variable which I am trying to create in qlikview.

Here is my expression:

=Count(Distinct{<CampaignId={'1743'}>}{<Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>+<Jour={'sam.'},Time={'>=04:00:00<=08:00:00'}>}{<Date={'>=$(=Date(Max(Date)))<=$(=Date(Max(Date)))'}>}Indice)

I need count of todays 'Indice' on the Campaign Id= 1743

And the time as mentionned above.

Any idea please.

Many Thanks,

Hasvine

Re: Error in expression

sasiparupudi1 — Fri, 21 Aug 2015 10:55:41 GMT

I would do it in two different counts and add them together.. please try the following expressions seperately in a text object to see if they work?

Count(Distinct{<CampaignId={'1743'},Jour={'<5'},Time={'>=04:00:00<=15:00:00'}>}Indice)

Count(Distinct{<Jour={'sam.'},Time={'>=04:00:00<=08:00:00'},Date={">=$(=Date(Max(Date)))<=$(=Date(Max(Date)))"}>}Indice)

also, I have observed Jour={'<5'} and Jour={'sam.'} which contradict each other.. one is numeric condition the other is a string..may be something missing ??

hth

Sasi

Re: Error in expression

Fri, 21 Aug 2015 11:08:09 GMT

I excluded the time frame and its working.

Thanks,

Hasvine