hi,
chart with a dimension:
=ValueList('a','b','c')
and the expression:
if (ValueList('a','b','c')='a',
'aa',
if (ValueList('a','b','c')='b',
'bb',
if (ValueList('a','b','c')='c',
'cc' ) ))
work!
the result is a table like this:
a aa
b bb
c cc
i change the expression in this way:
if (ValueList('a','b','c')='a',
'aa',
if (ValueList('a','b','c')='b',
aggr ( if ( $(vFattProgrEse) =0 and $(vFattProgrEse1) = 0 and $(vFattProgrEse2) > 0, Count ( distinct ST_CLIENTE)),ST_CLIENTE)
)
,
if (ValueList('a','b','c')='c',
'cc' ) ))
the aggr expression count the customers filtered in a certain way. the single expression work in others chart.
But in this chart with the "valuelist dimension" the result is:
a aa
c cc
the 'b' values is missing.
if i change the order in this way:
if (ValueList('a','b','c')='a',
count(
aggr ( if ( $(vFattProgrEse) =0 and $(vFattProgrEse1) = 0 and $(vFattProgrEse2) > 0, Count ( distinct ST_CLIENTE)),ST_CLIENTE)
)
,
if (ValueList('a','b','c')='b',
'bbì'
if (ValueList('a','b','c')='c',
'cc' ) ))
the result is
a 236
b bb
c cc
this work!
why?!?!?
this is just a basic example,to understand how it works
thanks in advance
