Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register 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