showing specific values of the whole dataset based on a selection

[#1]

Hey all,

for our Quality Department I would like to establish the following analysis:
We have notifications that are linked to a materialnumber which is affected by some specific error. If a quality manager selects a specific notification, I would like him to see all the notifications where the linked materialnumber has also occured:

Using the table below, by selection notification 1, I would like qlikview to create a graph which shows the notifications 1,4,6,8 and 10 since they are all about the same material.

Year	Notification	Material
2010	1	X
2010	2	Z
2010	3	Z
2011	4	X
2011	5	Z
2012	6	X
2013	7	Z
2014	8	X
2014	9	Z
2015	10	X

Thank you for your efforts!

best,

Sebastian

[Pulkit_Thukral]

Not Sure why u are taking Notification number as dimension when you could easily choose material to see all related Notifications.

[Kushal_Chawda]

Create variable on frontend vMaterial and put below expression

= Material

Select any notification

Now use below expression in chart

=sum({<Material={"$(=vMaterial)"},Notification=>}Amount)

[#4]

The use case is, that an analyst examines one specific notification where the development of the material within this notification shall be shown over the dimension year/month as additional information.

[tresesco]

You can use p() here. PFA

Exp used: Sum({<Notification, Material=P(Material)>}1)