topic Re: set analysis in QlikView

set analysis

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

Hi,

I need the below condition in set analysis..

(Sum({$} TOTAL SameStoreSalesTY)- Sum({$} TOTAL [Last Year MTD]))

where [Sold Location]={'17','18','29','70','76','102','105','129'}

Thanks..

Anil_Babu_Samineni — Mon, 03 Oct 2016 07:48:11 GMT

Perhaps This

(Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))

(Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({<Flag = {'$'}, [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD]))

sushil353 — Mon, 03 Oct 2016 08:09:02 GMT

Hi,

Try this:

(Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} SameStoreSalesTY)-

Sum(TOTAL {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>} [Last Year MTD])

)

HTH

nagarjuna_kotha — Mon, 03 Oct 2016 08:33:04 GMT

May be like this ?

Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL SameStoreSalesTY)

Sum ( {$<[Sold Location]={'17','18','29','70','76','102','105','129'}>}TOTAL [Last Year MTD] )

I hope this may helps you.

-Nagarjun

Anonymous — Thu, 17 Nov 2016 13:33:25 GMT

its showing some error

Anil_Babu_Samineni — Thu, 17 Nov 2016 13:43:30 GMT

What was the error? And In your Condition does $ is acting over there? I've removed Starting and Ending Parenthesis from my earlier set operator

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL SameStoreSalesTY) -

Sum({$< [Sold Location] = {'17','18','29','70','76','102','105','129'}>} TOTAL [Last Year MTD])

Anonymous — Sat, 19 Nov 2016 05:00:19 GMT

i need which requirement going to use this set analysis, please suggest.

i have been used one requirement but it not apt.