Correct function for range slider

Applicable88 — Thu, 07 May 2020 19:12:03 GMT

Hello Qlikcommunity,

rather long question here.

I have following data here:

Serialnumber	Material	Deliverynumber	Pos	Date of packing
BA1234567811	B2010	41540105	20	01.04.2020
BA2003012184	B2011	41540098	10	01.04.2020
BM2003012232	B2012	41540168	10	01.04.2020
BM2003010719	B2013	41540158	10	01.04.2020
BM2003012231	B2013	41540167	10	01.04.2020
GM2003010719	B2010	41540093	30	02.04.2020
GM2003012231	B2010	41540093	30	02.04.2020

Important information: Every serialnumber is unique , but every delivery can contain one or more serialnumber within the order.

Im using set analysis to make a bar chart:

Count( {< Serialnumber ={"BA*","BM*"} >} Serialnumber )

the other one: Count( {< Serialnumber ={"GM*","GC*","RL*","MC*"} >} Serialnumber )

So far no problem. But now I want to implement two different range sliders.

Of course both of them should take effect on filtering the data in the bar chart.

The first slider should show me all deliveries which exists more than one time, but only those whose serialnumber starts with BA* or BM*. Deliverynumbers which exists only one time must not be counted.

The second slider should filter the deliveries with more than one Position. But if there are two positions with value 10 it only should count as one.

Am I right when the slider is cannot use for expressions like these: Count( {< Serialnumber ={"BA*","BM*"} >} Serialnumber ) ??

I hope someone can help me.

Thank you very much and stay safe.

topic Correct function for range slider in App Development

Correct function for range slider