topic Re: how to use operaters in set analysis in QlikView

how to use operaters in set analysis

Thu, 30 Apr 2015 09:45:52 GMT

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

Re: how to use operaters in set analysis

arulsettu — Thu, 30 Apr 2015 09:49:14 GMT

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

Re: how to use operaters in set analysis

nagarjuna_kotha — Thu, 30 Apr 2015 09:49:57 GMT

Hi,

Kindly find below link .u ll understand easily.

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

Regards,

Nagarjuna

Re: how to use operaters in set analysis

nagarjuna_kotha — Thu, 30 Apr 2015 09:51:11 GMT

We can also use In Script level .

Re: how to use operaters in set analysis

prma7799 — Thu, 30 Apr 2015 09:52:07 GMT

Check this

Set Analysis: syntaxes, examples

Re: how to use operaters in set analysis

prma7799 — Thu, 30 Apr 2015 09:53:01 GMT

Set Analysis: syntaxes, examples

Learning Set Analysis from Scratch

Re: how to use operaters in set analysis

aapurva09 — Thu, 30 Apr 2015 09:53:06 GMT

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

Re: how to use operaters in set analysis

nagarjuna_kotha — Thu, 30 Apr 2015 10:03:26 GMT

Hi Apoorva,

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

EX :

Re: how to use operaters in set analysis

aapurva09 — Thu, 30 Apr 2015 10:16:33 GMT

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

Re: how to use operaters in set analysis

sunny_talwar — Thu, 30 Apr 2015 10:18:03 GMT

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

Re: how to use operaters in set analysis

ankitaag — Thu, 30 Apr 2015 10:25:02 GMT

=function({<condition>+<condition>})

=function({<condition>-<condition>})

=function({<condition>*<condition>})

=function({<condition>/<condition>})

Re: how to use operaters in set analysis

beck_bakytbek — Thu, 30 Apr 2015 22:09:07 GMT

Usually on the level of chart

so you can quckly change within of your chart

Beck

Re: how to use operaters in set analysis

beck_bakytbek — Thu, 30 Apr 2015 22:24:22 GMT

if you need more examples from me, just let me know

Beck

Re: how to use operaters in set analysis

ToniKautto — Thu, 30 Apr 2015 23:04:04 GMT

Based on your question referring to both script and sheet objects, I think the best thing for you is to read up on what exactly Set Analysis means. From this you will be able to understand the concept and then see how this would apply to your requirements.

There are some good references already made in the thread, but I would also suggest that you take a look at demo apps and see how set expressions are used for similar scenarios as yours.

Qlik Demos: See QlikView in Action | Demo.Qlik.Com

There is also a wizard provided by swr‌‌ to make it easier to find the set expression syntax.

Set Analysis Wizard for QlikView | qlikblog.at