topic Re: Set analysis in QlikView

Set analysis

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

I'm getting the expression error while writing the logic.

Error is at Highlighted arrow.Please find the below.

Logic :

If(District_RetailScorecard = 'Company' or [Sold Location] = '999',

(sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}>}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

If(/*District_RetailScorecard='District' or*/ [Sold Location] = '888',

(sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}>},'M/D/YYYY'))"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

(sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}>}, 'M/D/YYYY'))"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} [Store Quota Amount]) * vMTDQ))

Image:

Thanks..

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 13:00:30 GMT

See if this helps:

[Sold Location] ={'*'} - {'040', '051', '099', '531', '800', '090','108'}

Re: Set analysis

Anonymous — Thu, 06 Oct 2016 13:01:53 GMT

try to Change the sign - before = (minus before equal)

[Sold Location] -= {

Re: Set analysis

nareshthavidishetty — Thu, 06 Oct 2016 13:18:52 GMT

Hi Sunny,

Still am getting the error..Please find below,

Thanks..

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 13:21:29 GMT

My bad, your error is here:

sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}>}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

Those need to be removed

sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

Re: Set analysis

trdandamudi — Thu, 06 Oct 2016 13:23:24 GMT

May be as below:

[Sold Location] - = {'040', '051', '099', '531', '800', '090','108'}>}

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 13:25:30 GMT

I don't think that is an issue. This just says that the result should change based on selection vs what he has won't change based on selections. I think the issue is here

Re: Set analysis

trdandamudi — Thu, 06 Oct 2016 13:30:40 GMT

You have a point and it makes sense.... Also having the - (minus sign) after = (Equal) is incorrect or not ?

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 13:35:03 GMT

I think it is not incorrect to have it there.

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 13:36:51 GMT

In simple terms, it is correct to have a negative after the equal sign

Re: Set analysis

jyothish8807 — Thu, 06 Oct 2016 13:40:03 GMT

Hi Naresh,

I found two issues, which i have highlighted in red:

If(District_RetailScorecard = 'Company' or [Sold Location] = '999',

(sum({1<[Reported Date] = {"$(='>=7/1/2016<=7/31/2016')"}removed >}, [Sold Location] -={'040', '051', '099', '531', '800', '090','108'}>} TOTAL [Store Quota Amount]) * vMTDQ),

Regards

Re: Set analysis

Anil_Babu_Samineni — Thu, 06 Oct 2016 14:39:15 GMT

Try This

Logic :

If(District_RetailScorecard = 'Company' or [Sold Location] = '999',

(sum(TOTAL {1<[Reported Date] = {"Date(=$('>=' & 7/1/2016 '<=' & 7/31/2016')"}>}, 'M/D/YYYY')"}, [Sold Location] -= {'040', '051', '099', '531', '800', '090','108'}>} [Store Quota Amount]) * vMTDQ),

If(/*District_RetailScorecard='District' or*/ [Sold Location] = '888',

(sum({1<[Reported Date] = {"Date(=$('>=' & 7/1/2016 '<=' & 7/31/2016')"}>}, 'M/D/YYYY')"}, [Sold Location] -= {'040', '051', '099', '531', '800', '090','108'}>} [Store Quota Amount]) * vMTDQ))

Re: Set analysis

nareshthavidishetty — Thu, 06 Oct 2016 14:40:17 GMT

Hi,

Still Getting the error..

I have simply test below logic in text object and it gives 'Error in set modifier expression'

Logic:=sum({1<[Reported Date]={"$(='>=7/1/2016'<='7/31/2016')"}TOTAL [Store Quota Amount]))

Thanks..

Re: Set analysis

Anil_Babu_Samineni — Thu, 06 Oct 2016 14:42:47 GMT

Is there any chance to share the Application. Because, It seems typo error. We will figure out if we get your application

Re: Set analysis

sunny_talwar — Thu, 06 Oct 2016 14:43:07 GMT

Where did you Sold Location set modifier go?

Try one of these:

=sum({1<[Reported Date]={"$(='>=7/1/2016'<='7/31/2016')"}>} TOTAL [Store Quota Amount]))

=sum({1<[Reported Date]={"$(='>=7/1/2016'<='7/31/2016')"}, [Sold Location] =- {'040', '051', '099', '531', '800', '090','108'}>}TOTAL [Store Quota Amount]))