Set Analysis

Wed, 09 Jul 2014 09:22:41 GMT

Hello,

I'm using the below expression in my chart.

=pick(match(ValueList($(v_current_ValueList)),
$(v_current_ValueList)),
if ('$(vService)' = 'ALL', sum( $(v_YTD) [Montant Total - FACT_FACTURATION]),
sum($(v_YTD) {<Service={'$(vService)'}>} [Montant Total - FACT_FACTURATION])))

----

v_YTD : Year ta date variable.

v_YTD = {$<
[Mois]=,[Mois ]=,[Année]=,[Période]=,[AnnéeMois]=,[Date]=,[Mois-Année]=,

[Année] = {$(=Max([Année]))},
[Mois] = {"<=$(=Max([Mois]))"}

Could anone help on this?

Thanks.

Houria

topic Set Analysis in QlikView

Set Analysis