Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

Filtration gauge chart

hi,

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

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

Luke_Killer_IT_0-1624864940495.png

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)
),'#.###,##')

1 Reply
Luke_Killer_IT
Creator
Creator
Author

Hi,

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

Luke_Killer_IT_0-1624952157872.png

Luke_Killer_IT_1-1624952175577.png