topic Comparative Analysis in QlikView

Comparative Analysis

Sat, 03 Mar 2012 07:14:46 GMT

hi,

Could anyone tell me about comparative analysis which is a new feature in QV11.

I have found little on http://community.qlik.com/docs/DOC-2581#Theme_Comparative_Analysis but its very theoretical.

Regards

arun goel

Comparative Analysis

phaneendra_kunc — Sat, 03 Mar 2012 07:50:55 GMT

See if this helps...

http://community.qlik.com/thread/40766

Go through the attached example in the above thread..

Regards,

Phani

Re: Comparative Analysis

Sat, 03 Mar 2012 19:10:17 GMT

Hi Phaneedra,

I'll try to explain the concept and the thechnical side of it,

Let's say we want to analyse the conection between two products we sale,

and we want to analyse it dinamcly between any products wh own,

In QV it's now realy easy to make a kind of duplicate the set of the data we have,

Actually we know that if we choose one product from a ListBox we will see the information abuot the product we chose,now we can declar thet we want same selections on another ListBox with the same Dimmension- product- refer to anoter side of the data we have (duplicate set the data) ,

Thechnicaly, you can create a set of data by settings->document properties->Alternate States.

We know that the $ sign mean that we want consider all the selection of our data- the dafult,

And the the expriesion is :

Function({$}field_name) ->sum({$}Sales)

Now after we declar anoter state, lets say we called it Group1, we can use in Set Analysis :

Function({[State Identifier]}field_name) ->sum({[Group 1]} Sales)

Its important to understand that itlike s behave another set of data (theoreticly).

I attach an example.

I hope it will help you.

Yigal.

Re: Comparative Analysis

Thu, 27 Dec 2012 21:19:57 GMT

Hi yigal,

in which tab do you set up the property "alternate state".

best regards

christian

Re: Comparative Analysis

Fri, 28 Dec 2012 14:25:47 GMT

Hi,

First you declares on State in :

Its Important to know that there is a hirarhy for the states ,

And then you can assign any objects to the state you created:

Hope it helps,

Regard,

Yigal

Re: Comparative Analysis

Sun, 30 Dec 2012 21:44:26 GMT

Thank you Yigal

best regards

and happy new year

christian

Selon Yigal BO <qcwebmaster@qlik.com>:

Yigal BO created the
discussion
"Re: Comparative Analysis"
To view the discussion, visit:
http://community.qlik.com/message/295364#295364