topic Re: Animated dimension & set analysis in QlikView

Animated dimension & set analysis

Fri, 20 Sep 2013 15:55:58 GMT

Ciao.

I have a problem with animated dimension and set analysis.

The chart that you see in the document has 'Anno' (year) as animated dimension.

In the same chart, ther are 3 expression:

1. 'Femmine' (woman) = sum({$<Sesso={F}>} Data).

2. 'Maschi' (man) = sum({$<Sesso={M}>} Data).

3. 'Femmine al 2013' (woman in year 2013) =sum({$<Sesso={F},Anno={'2013'}>} Data).

The data structure is:

I expect that the expression 'Femmine al 2013' is always visible, but I see the values on the graph only when 'year' = 2013.

Can someone help me please?

Thanks.

Ciao. Michele.

Re: Animated dimension & set analysis

manas_bn — Fri, 20 Sep 2013 18:33:37 GMT

Hi Michele,

I didn't get much time to look at this, but you probably should use AGGR function for the line.

Below expression works for Femmine al 2013, but only when you select a particular year (or not select any year at all)!

aggr(sum({$<Sesso={F},Anno={2013}>} Data),Eta)

May be also look at using the Reference Line function in the Presentation tab...

Hope this helps!

Manas

Re: Animated dimension & set analysis

chematos — Fri, 20 Sep 2013 18:35:07 GMT

I think you can't use the same field as an animated dimension and the 3d expression because when you use that in the expression you are filtering the field by that value, but try this just in case:

=sum({1<Sesso={F},Anno={'2013'}>} Data)

Re: Animated dimension & set analysis

Mon, 23 Sep 2013 12:32:35 GMT

I tried your suggestion, but unfortunately does not solve the problem.

Even the reference line does not work.

Thank you .

Re: Animated dimension & set analysis

Mon, 23 Sep 2013 12:35:05 GMT

It seems that animated dimensions are stronger than Set Analysis.

Thank you. .