topic Condition in dimension in QlikView

Condition in dimension

Mon, 05 Nov 2012 16:20:15 GMT

Hi,

In the Background Color property of a dimension i apply this condition :

=if (Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1

and Sum({$ <[Type adhérent]={Collectif}>}NB_ADH_PORTEFEUILLE) = Sum({$ <[Type adhérent]={Collectif},

REIMMATRICULATION={NON}, Année={$(vAnnée)} >} NB_ADH_PROD_NETTE) , RGB(255,0,0))

It works fine for the backgrounbd color.

But i don't know how to apply this condition to the dimension : only the values that apply this condition appear.

Thanks and sorry for my english.

Re: Condition in dimension

whiteline — Mon, 05 Nov 2012 16:36:01 GMT

Hi.

You don't provide the name of field for that dimension.

Try to use something like this as calculated dimension:

=aggr(if(Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1 and

Sum({$ <[Type adhérent]={Collectif}>}NB_ADH_PORTEFEUILLE) =

Sum({$ <[Type adhérent]={Collectif}, REIMMATRICULATION={NON}, Année={$(vAnnée)} >}NB_ADH_PROD_NETTE) , [Your dimension field name], null()), [Your dimension field name])

Re: Condition in dimension

Tue, 06 Nov 2012 10:09:44 GMT

Hi,

Here what i've done :

=aggr(if(Sum({$ <[Type adhérent]={Collectif}, Année=>} NB_ADH_RAD_NETTE)<1 and

Sum({$ <[Type adhérent]={Collectif}>} NB_ADH_PORTEFEUILLE) =

Sum({$ <[Type adhérent]={Collectif}, REIMMATRICULATION={NON}, Année = {$(vAnnée)}>}NB_ADH_PROD_NETTE) , PARTENAIRE, null()), PARTENAIRE)

It works fine.

Thanks a lot.