topic calculated dimensions & getfieldselections in QlikView

calculated dimensions & getfieldselections

Wed, 30 Nov 2011 15:40:47 GMT

Hi all,

I´ve been working with basic calculated dimensions.

=if( isnull(date(DATAHORAENVIO)),date(DATAHORAFECHAMENTO),date(DATAHORAENVIO)) works fine and others like that.

i now want to use the getfieldselections with it, has any one experience??.

I WOULD LIKE TO "PASS" to the table the dimensions CONVENIO chosen dinamically, so what is selected is used to calculate the dimension CONVENIO2.

=if(CONVENIO2 = '$(getfieldselections (CONVENIO),',')',CONVENIO2,NULL())

gives a (Expresion OK) but //error in dimens on the pivot table

Any ideas?

IS this possible ?

Thanks in advance

calculated dimensions & getfieldselections

swuehl — Thu, 01 Dec 2011 15:07:21 GMT

Try

=aggr(only({<CONVENIO2=CONVENIO>} CONVENIO2), CONVENIO2)

Hope this helps,

Stefan

calculated dimensions & getfieldselections

Thu, 01 Dec 2011 19:01:57 GMT

Thanks Stefan,

It is not working on the calculated dimension either on a text box.

I forgot to say is QV 8.5, when these were launched.

Any other idea.?

Thank on advance

Sergio

calculated dimensions & getfieldselections

swuehl — Thu, 01 Dec 2011 23:40:28 GMT

Hm, I haven't worked with 8.5 too much, so I am not quite sure what the limitations are.

I assume set analysis is not working well, but I hope something like this might work (it works with QV10)

=if(WildMatch(GetFieldSelections(CONVENIO),'*'& CONVENIO2 &'*'),CONVENIO2,NULL())

Regards,

Stefan

calculated dimensions & getfieldselections

Fri, 02 Dec 2011 13:04:37 GMT

Stefan,

Thank you very much.

This was the way.

I will explain the situation to make it more clear for the QLIKCOMMUNITY.

In order to avoid circular refernces i loaded twice the same dimension (well one was mapping).

Every thing OK when using them in diferent pages.

But when you need to calculate stuff of the second one in the same page, and the shown (selectable) dimension is the first one.??????

I created a calculated dimension on the pivot table of the second dimenssion based on what was selected from the first one.

=if(WildMatch(GetFieldSelections(CONVENIO),'*'& CONVENIO2 &'*'),CONVENIO2,NULL())

And that did it.

But when nothing is selected, nothing apears....

So created 2 iqual charts where on LAYOUT >>show>> condition...

One has a count(getfieldselections(Convenio)) =0 and no calculated dimension.

and the other has a

count(getfieldselections(Convenio)) >=1 and the calculated dimension.

And works perfect.

Thank you so much.

Sergio