Filtration gauge chart

Luke_Killer_IT — Tue, 29 Jun 2021 07:47:38 GMT

hi,

how to make this chart show only data from mandate 300?

I don't want to select a list box like this

this is my code:

num(
(
sum(aggr(SUM({<ML_Ort.LagerOrt={2000},S_Artikel.Firma={300,310}>} MLA_OnHand.OnHand)
*avg({<ML_Ort.LagerOrt={2000}>} c_LagerBestand.c_Dpr/c_LagerBestand.xc_Kurs),MLA_OnHand.Part))
+
sum(aggr(SUM({<ML_Ort.LagerOrt={2000},S_Artikel.Firma-={300,310}>} MLA_OnHand.OnHand)
*avg({<ML_Ort.LagerOrt={2000}>}c_LagerBestand.c_Dpr),MLA_OnHand.Part))
)
/
(
(sum(aggr(SUM({<S_Artikel.Firma-={'300','310'},ML_Ort.LagerOrt={2000}>}
MLL_Movements.Quantity *MLL_Movements.c_Dpr),MLL_Movements.Documentnumber)) * -1 )
+
(sum(aggr(SUM(
MLL_Movements.Quantity *MLL_Movements.c_Dpr / MLL_Movements.xc_Kurs),MLL_Movements.Documentnumber)) * -1)
),'#.###,##')

Re: Filtration chart

Luke_Killer_IT — Tue, 29 Jun 2021 07:36:31 GMT

Hi,

I used if (s_artikel.company = number, num (..)) but this is what it looks like and I want everything to be visible

topic Filtration gauge chart in QlikView

Filtration gauge chart

Re: Filtration chart