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.