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: 
nareshthavidishetty
Creator III
Creator III

set analysis

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

6 Replies
Anil_Babu_Samineni

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]))


OR


(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]))

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sushil353
Master II
Master II

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
Partner - Specialist II
Partner - Specialist II

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
Not applicable

its showing some error

Anil_Babu_Samineni

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])

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

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

i have been used one requirement but it not apt.