topic Re: Set Analysis Information in QlikView

Set Analysis Information

Tue, 01 Jul 2014 09:20:30 GMT

Hi,

I'ld like to know how & where did I use a set analysis ?

Thx in advice,

Re: Set Analysis Information

arulsettu — Tue, 01 Jul 2014 09:23:49 GMT

we have created a set of data which we want to use. In a similar fashion, using Set Analysis feature, we can pre-define the data to be displayed in our charts.

Re: Set Analysis Information

arulsettu — Tue, 01 Jul 2014 09:25:56 GMT

or refer this

Set Analysis: syntaxes, examples

Re: Set Analysis Information

ashfaq_haseeb — Tue, 01 Jul 2014 09:36:19 GMT

Hi,

Look at the attached document.

Regards

ASHFAQ

Re: Set Analysis Information

Tue, 01 Jul 2014 09:39:58 GMT

Hi,

check this out

Re: Set Analysis Information

Tue, 01 Jul 2014 09:46:31 GMT

thx guyz !

Re: Set Analysis Information

Tue, 01 Jul 2014 09:57:48 GMT

I'm trying to make my first one :

I have to make an expression that give me 1 information in 2012. The rest of the line is on an other Date (2014)

={<[Date Solde]=201212>}[Montant Solde])

Re: Set Analysis Information

Tue, 01 Jul 2014 10:01:31 GMT

Please find the attachement hope this will helps you

Re: Set Analysis Information

ashfaq_haseeb — Tue, 01 Jul 2014 10:01:52 GMT

Hi,

In Back-end try to create a field called year.

Load

[Date Solde],

Year([Date Solde]) as Year,

.From table.

and use below in text box

=sum({<[Year]={2012}>}[Montant Solde])

Regards

ASHFAQ

Re: Set Analysis Information

arulsettu — Tue, 01 Jul 2014 10:02:42 GMT

try like this

=sum({<[Date Solde]={2012}>}[Montant Solde])