Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis

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

0 Replies