Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use operaters in set analysis

pls tell how to use in operaters in set analysis where it is use either script level or chart level...................

13 Replies
arulsettu
Master III
Master III

sum(1-${<year={'2015'}>}sales)

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

Kindly find below link .u ll understand easily.

http://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/

Regards,

Nagarjuna

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

We can also use In Script level .

prma7799
Master III
Master III

aapurva09
Creator
Creator

Hi Rahul,

Set Analysis can not be used at script level. Please go through Set Analysis in Qlikview Help or Reference Manual. It will show you its usage.

Thanks,

Apurva

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi Apoorva,

We can use Set analysis in script level.Have a look below.

EX :

Set in Script.PNG

aapurva09
Creator
Creator

Hi Nagarjuna,

That is not Set Analysis. sum() is an Aggregation function that can be used at script level with group by clause.

Set analysis has Modifiers, Identifiers that can not be used in Script.

thanks,

Apurva

sunny_talwar

I agree with Apurva Jha‌, I don't think set analysis can be used at the script level. Its used in the front end of the application.

Best,

Sunny